How to SUMIF + IF without !VALUE#

[JC-PS]

Hi, I,m John.
I have on time format "h,mm" next trying to add cells:
I'll appreciate any help.

 

[Héctor Miguel]

hi, John !

I have on time format "h,mm" next trying to add cells:
I'll appreciate any help.

1) note that your "sumif" part of the formula...
a) the "left" function is (apparently) over-used and it's the same as: =SUMIF(H34:H38,"se",K34:K38)
b) *IF* the intention is compare the 2 left characters within the range H3:H38 it's not working like that -???-

2) (perhaps) any or both "values" in cells P37 and R37 are "text-values" resulting from other =IF(... functions -???-

hth,
hector.

 

[ShaneDevenshire]

Hi,

Actually the first formula could be replaced with

=SUMIF(H34:H38,"se*",K34:K38)

be careful the * (astricks) is needed!

Then increase it to read

=SUMIF(H34:H38,"se*",K34:K38)+IF(LEFT(O37,2)="se",P37,0)+IF(LEFT(Q37,2)="se",R37,0)


Thanks,
Shane Devenshire

 

[JC-PS]

hi, John !


1) note that your "sumif" part of the formula...
a) the "left" function is (apparently) over-used and it's the same as: =SUMIF(H34:H38,"se",K34:K38)
b) *IF* the intention is compare the 2 left characters within the range H3:H38 it's not working like that -???-

2) (perhaps) any or both "values" in cells P37 and R37 are "text-values" resulting from other =IF(... functions -???-

hth,
hector.