help with sum if function
 

How can i use sum if function to sum numbers in columns O20:O33 only if cell
C14 has a "N' in it.

help with sum if function
 

Do you mean Rows O20 to O33, if so try:-

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

Mike

"bl_johnson_19" wrote:

How can i use sum if function to sum numbers in columns O20:O33 only if cell
C14 has a "N' in it.

help with sum if function
 

=IF(C14="n",SUM(o20:o33),"")

"bl_johnson_19" wrote:

How can i use sum if function to sum numbers in columns O20:O33 only if cell
C14 has a "N' in it.

help with sum if function
 

=(C14="N")*SUM(O20:O33)


"bl_johnson_19" wrote:

How can i use sum if function to sum numbers in columns O20:O33 only if cell
C14 has a "N' in it.

help with sum if function
 

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.


"Mike H" wrote:

Do you mean Rows O20 to O33, if so try:-

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

Mike

"bl_johnson_19" wrote:

How can i use sum if function to sum numbers in columns O20:O33 only if cell
C14 has a "N' in it.

help with sum if function
 

Works for me .... check the text string ,"Float. Hol/B-day" is correct and/or
data in N is numeric not text.

"bl_johnson_19" wrote:

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.


"Mike H" wrote:

Do you mean Rows O20 to O33, if so try:-

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

Mike

"bl_johnson_19" wrote:

How can i use sum if function to sum numbers in columns O20:O33 only if cell
C14 has a "N' in it.

help with sum if function
 

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),"")




"Mike H" wrote:

Do you mean Rows O20 to O33, if so try:-

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

Mike

"bl_johnson_19" wrote:

How can i use sum if function to sum numbers in columns O20:O33 only if cell
C14 has a "N' in it.

help with sum if function
 

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),"")




"Mike H" wrote:

Do you mean Rows O20 to O33, if so try:-

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

Mike

"bl_johnson_19" wrote:

How can i use sum if function to sum numbers in columns O20:O33 only if cell
C14 has a "N' in it.