SS Mathematical Functions
Summing Cells
Summing Cells
=SUM(C1:C34)
Sum all the numbers in the range C1 to C34
Summing Cells By Value
Summing Cells By Value
=SUMIF($B$1:$B$34,$B36,C$1:C$34)
If a cell value in the range B1 to B34 matches the value in B36 then sum the corresponding values from the range C1 to C34.
Summing Cells By Two Values
Summing Cells By Two Values
=SUMPRODUCT((B2:M14)*(B1:M1=P2)*(A2:A14=P3))Â
To sum all values in the range B2:M14 where the value in the range B1:M1 matches the value in P2 and the value in the range A2:14 matches the value in P3
Maximum/Minimum
Maximum/Minimum
=MIN(A2:B2)
=IF(A2<B2,A2,B2)
Return the lower value of the values in A2 and B2
=MAX(A2,B2)
=IF(A2>B2,A2,B2)
Return the higher value of the values in A2 and B2
=MIN(SUMIF($A$3:$A$351,$Y355,V$3:V$351),$I355)
If the value in I355 is lower than the result of the SUMIF function then return the value in I355 else return the result of the SUMIF. The "$" limits which elements will change when this is pasted to another cell.
Alphabetic MIN/MAX
Alphabetic MIN/MAX
Logic
Logic
Bibliography
Bibliography
AVERAGEhttps://www.extendoffice.com/documents/excel/1574-excel-average-without-max-and-min.html
SUMhttps://exceljet.net/excel-functions/excel-sum-function
SUMIFhttps://exceljet.net/excel-functions/excel-sumif-function
SUMIFShttps://productivityspot.com/google-sheets-sumifs-date-range/https://blog.golayer.io/google-sheets/sumif-sumifs-google-sheets
SUMPRODUCThttps://www.exceltip.com/summing/how-to-sum-by-matching-row-and-column.htmlhttps://support.microsoft.com/en-gb/office/sumproduct-function-16753e75-9f68-4874-94ac-4d2145a2fd2e
MAX/MINhttps://exceljet.net/formula/larger-of-two-valueshttps://exceljet.net/replace-ugly-ifs-with-max-or-minhttps://exceljet.net/excel-functions/excel-min-functionhttps://exceljet.net/excel-functions/excel-max-functionhttps://www.extendoffice.com/documents/excel/5920-excel-formula-whichever-is-lower-higher.htmlhttps://www.extendoffice.com/documents/excel/1978-excel-find-max-value-in-a-group.htmlhttps://www.extendoffice.com/documents/excel/2683-excel-find-max-min-value-based-on-criteria.htmlhttps://excelchamps.com/formulas/if-negative-then-zero/https://answers.microsoft.com/en-us/msoffice/forum/all/formula-for-if-cell-value-less-than-0-display-0-or/31a1b2d0-0a2c-4423-a5a2-98db063bde05https://excelchamps.com/formulas/if-negative-then-zero
Alphabetic Min/Maxhttps://www.exceltip.com/lookup-formulas/finding-the-maximal-minimal-string-based-on-alphabetic-order.html
Logichttps://support.google.com/docs/answer/9116491?hl=en&ref_topic=3105413&sjid=16553262634211041399-EU# (XOR)https://support.google.com/docs/answer/3093301?hl=en&ref_topic=3105413&sjid=16553262634211041399-EU# (AND)https://support.google.com/docs/answer/3093306?hl=en&ref_topic=3105413 (OR)https://support.google.com/docs/answer/3093305?hl=en&ref_topic=3105413 (NOT)
SUMhttps://exceljet.net/excel-functions/excel-sum-function
SUMIFhttps://exceljet.net/excel-functions/excel-sumif-function
SUMIFShttps://productivityspot.com/google-sheets-sumifs-date-range/https://blog.golayer.io/google-sheets/sumif-sumifs-google-sheets
SUMPRODUCThttps://www.exceltip.com/summing/how-to-sum-by-matching-row-and-column.htmlhttps://support.microsoft.com/en-gb/office/sumproduct-function-16753e75-9f68-4874-94ac-4d2145a2fd2e
MAX/MINhttps://exceljet.net/formula/larger-of-two-valueshttps://exceljet.net/replace-ugly-ifs-with-max-or-minhttps://exceljet.net/excel-functions/excel-min-functionhttps://exceljet.net/excel-functions/excel-max-functionhttps://www.extendoffice.com/documents/excel/5920-excel-formula-whichever-is-lower-higher.htmlhttps://www.extendoffice.com/documents/excel/1978-excel-find-max-value-in-a-group.htmlhttps://www.extendoffice.com/documents/excel/2683-excel-find-max-min-value-based-on-criteria.htmlhttps://excelchamps.com/formulas/if-negative-then-zero/https://answers.microsoft.com/en-us/msoffice/forum/all/formula-for-if-cell-value-less-than-0-display-0-or/31a1b2d0-0a2c-4423-a5a2-98db063bde05https://excelchamps.com/formulas/if-negative-then-zero
Alphabetic Min/Maxhttps://www.exceltip.com/lookup-formulas/finding-the-maximal-minimal-string-based-on-alphabetic-order.html
Logichttps://support.google.com/docs/answer/9116491?hl=en&ref_topic=3105413&sjid=16553262634211041399-EU# (XOR)https://support.google.com/docs/answer/3093301?hl=en&ref_topic=3105413&sjid=16553262634211041399-EU# (AND)https://support.google.com/docs/answer/3093306?hl=en&ref_topic=3105413 (OR)https://support.google.com/docs/answer/3093305?hl=en&ref_topic=3105413 (NOT)