Embedded Files
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
Summing Cells By Date Range
Summing Cells By Date Range
=SUMIFS(B2:B100, A2:A100, ">="&(EOMONTH(A2, -1) + 1), A2:A100, "<="&EOMONTH(A2, 0))
Apple Numbers syntaxSum values from B2:B100 where dates in A2:A100 are between start of month and end of month for date in column A of the current row.
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
https://exceljet.net/excels-racon-functions
AVERAGEhttps://www.extendoffice.com/documents/excel/1574-excel-average-without-max-and-min.htmlhttps://www.w3schools.com/excel/excel_average.php
AVERAGEIFhttps://www.w3schools.com/excel/excel_averageif.php
AVERAGEIFShttps://www.w3schools.com/excel/excel_averageifs.php
COUNTIFhttps://www.ablebits.com/office-addins-blog/excel-countif-function-examples/https://support.microsoft.com/en-gb/office/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34https://www.statology.org/count-frequency-of-text-in-excel/https://www.w3schools.com/excel/excel_countif.php
COUNTIFShttps://exceljet.net/excel-functions/excel-countifs-functionhttps://www.w3schools.com/excel/excel_countifs.phphttps://support.microsoft.com/en-gb/office/countifs-function-dda3dc6e-f74e-4aee-88bc-aa8c2a866842
FIXEDhttps://support.microsoft.com/en-gb/office/fixed-function-ffd5723c-324c-45e9-8b96-e41be2a8274a
LARGEhttps://www.ablebits.com/office-addins-blog/large-if-formula-excel/https://www.excelchamp.net/finding-the-second-largest-value-in-excelhttps://support.google.com/docs/answer/3094008
SUBTOTALhttps://support.microsoft.com/en-gb/office/subtotal-function-7b027003-f060-4ade-9040-e478765b9939https://excelchamps.com/formulas/sum-only-visible-cells
SUMhttps://exceljet.net/excel-functions/excel-sum-functionhttps://www.w3schools.com/excel/excel_sum.php
SUMIFhttps://exceljet.net/excel-functions/excel-sumif-functionhttps://www.w3schools.com/excel/excel_sumif.php
SUMIFShttps://productivityspot.com/google-sheets-sumifs-date-range/https://blog.golayer.io/google-sheets/sumif-sumifs-google-sheetshttps://www.w3schools.com/excel/excel_sumifs.phphttps://support.microsoft.com/en-gb/office/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b
SUMPRODUCThttps://www.exceltip.com/summing/how-to-sum-by-matching-row-and-column.htmlhttps://www.exceltip.com/excel-functions/how-to-use-the-sumproduct-function-in-excel.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-zerohttps://www.w3schools.com/excel/excel_max.phphttps://www.w3schools.com/excel/excel_min.php
MAXIFhttps://www.automateexcel.com/formulas/max-if-with-condition/
MAXIFShttps://www.automateexcel.com/formulas/max-if-with-condition/
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)
AVERAGEhttps://www.extendoffice.com/documents/excel/1574-excel-average-without-max-and-min.htmlhttps://www.w3schools.com/excel/excel_average.php
AVERAGEIFhttps://www.w3schools.com/excel/excel_averageif.php
AVERAGEIFShttps://www.w3schools.com/excel/excel_averageifs.php
COUNTIFhttps://www.ablebits.com/office-addins-blog/excel-countif-function-examples/https://support.microsoft.com/en-gb/office/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34https://www.statology.org/count-frequency-of-text-in-excel/https://www.w3schools.com/excel/excel_countif.php
COUNTIFShttps://exceljet.net/excel-functions/excel-countifs-functionhttps://www.w3schools.com/excel/excel_countifs.phphttps://support.microsoft.com/en-gb/office/countifs-function-dda3dc6e-f74e-4aee-88bc-aa8c2a866842
FIXEDhttps://support.microsoft.com/en-gb/office/fixed-function-ffd5723c-324c-45e9-8b96-e41be2a8274a
LARGEhttps://www.ablebits.com/office-addins-blog/large-if-formula-excel/https://www.excelchamp.net/finding-the-second-largest-value-in-excelhttps://support.google.com/docs/answer/3094008
SUBTOTALhttps://support.microsoft.com/en-gb/office/subtotal-function-7b027003-f060-4ade-9040-e478765b9939https://excelchamps.com/formulas/sum-only-visible-cells
SUMhttps://exceljet.net/excel-functions/excel-sum-functionhttps://www.w3schools.com/excel/excel_sum.php
SUMIFhttps://exceljet.net/excel-functions/excel-sumif-functionhttps://www.w3schools.com/excel/excel_sumif.php
SUMIFShttps://productivityspot.com/google-sheets-sumifs-date-range/https://blog.golayer.io/google-sheets/sumif-sumifs-google-sheetshttps://www.w3schools.com/excel/excel_sumifs.phphttps://support.microsoft.com/en-gb/office/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b
SUMPRODUCThttps://www.exceltip.com/summing/how-to-sum-by-matching-row-and-column.htmlhttps://www.exceltip.com/excel-functions/how-to-use-the-sumproduct-function-in-excel.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-zerohttps://www.w3schools.com/excel/excel_max.phphttps://www.w3schools.com/excel/excel_min.php
MAXIFhttps://www.automateexcel.com/formulas/max-if-with-condition/
MAXIFShttps://www.automateexcel.com/formulas/max-if-with-condition/
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)
Page updated
Google Sites
Report abuse