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

Transfer data between two tables 3
Dealing with the error: unable to filter on excel hc home school 0
Use TODAY() function as the criteria in a SUMIF formula 1
SUMIF with criteria "<>" & "=" 4
Cumulative formula for word table 0
use month in cell date to sum all relevant cells 2
sumif issues 1
Sumif apllying to all sheets in workbook 2

Top