SUMIF Function ?

J

Joey

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.
 
G

Gary''s Student

=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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine Sumif and Countif 3
SUMIF on a Calculated Field 3
SUMIF with criteria "<>" & "=" 4
SUMIF Multiple Criteria in different ranges. 13
subtotal with sumif nested 1
SUMIF with Multiple Criteria 4
=sumif function 1
Specifying comparision criteria with SUMIF() 2

Top