help with sum if function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can i use sum if function to sum numbers in columns O20:O33 only if cell
C14 has a "N' in it.
 
Do you mean Rows O20 to O33, if so try:-

=IF(C14="N",SUM(O23:O33),"")

Mike
 
I have the following formulain my worksheet...

=IF(C14="N",SUMIF(O20:O33,"Float. Hol/B-day",N20:N33),"0")

Any idea why it won't work? In column N20 to N33 there is an 8 which should
appear in cell C54.
 
Works for me .... check the text string ,"Float. Hol/B-day" is correct and/or
data in N is numeric not text.
 
I went ahead and entered the formula below, which is working o.k. but when I
take the same formula, and change the IF($C$14="D" to "N".. it will not work.
It DID work the first time I put the formula in...

=IF($C$14="D",SUMIF($O$20:$O$33,"Float. Hol/B-day",$N$20:$N$33),"")
 
You must log in or register to reply here.

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

If statement 2
I have a complex formula where I need to build in a MAX function 4
help with sum if function 1
adding subtotals from several worksheets 2
Hiding Formula Answers in Specific Cells 1
SUM(ADDRESS(ROW(C2),COLUMN(C2),1,TRUE):ADDRESS(C14+1,COLUMN(C2),1, 5
Duplicate listing 2
IF AND Nested Functions - Formula Not Working 0

Back
Top