B
bl_johnson_19
How can i use sum if function to sum numbers in columns O20:O33 only if cell
C14 has a "N' in it.
C14 has a "N' in it.
M
Mike H
Do you mean Rows O20 to O33, if so try:-
=IF(C14="N",SUM(O23:O33),"")
Mike
=IF(C14="N",SUM(O23:O33),"")
Mike
R
Rich
=IF(C14="n",SUM(o20
33),"")
33),"")
T
Teethless mama
=(C14="N")*SUM(O20:O33)
B
bl_johnson_19
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.
=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.
T
Toppers
Works for me .... check the text string ,"Float. Hol/B-day" is correct and/or
data in N is numeric not text.
data in N is numeric not text.
B
bl_johnson_19
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),"")
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),"")