ExcelBanter - SUMIF Function ?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SUMIF Function ? (https://www.excelbanter.com/excel-worksheet-functions/224658-sumif-function.html)

Joey

SUMIF Function ?

How do I enter a sumif function to sum cells in column D in the range D3:D216
that match cell H3 criteria using absolute or relative cell references ?
Please Help.

Gary''s Student

SUMIF Function ?

=SUMIF(D:D,H3) sum the values equal to H3
=SUMIF(D:D,"<" &H3) sum the values less than H3
=SUMIF(D:D,"" & H3) sum the values greater than H3

etc.

--
Gary''s Student - gsnu200839

"Joey" wrote:

How do I enter a sumif function to sum cells in column D in the range D3:D216
that match cell H3 criteria using absolute or relative cell references ?
Please Help.

All times are GMT +1. The time now is 10:46 PM.