How to SUMIF + IF without !VALUE#

  • Thread starter Thread starter JC-PS
  • Start date Start date
J

JC-PS

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

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.
 
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
 
Héctor Miguel said:
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.
Click to expand...
 
Back
Top