What's Wrong With This?

  • Thread starter Thread starter Unsigned
  • Start date Start date
U

Unsigned

I'm trying to apply the following formula to cell h8:
=sumif(c8:d8, >0, f7 + c8 - d8)
My aim is if cells c8 & d8 = 0 they remaine blank. If a value is entered in
either c8 or d8, the sum of f7 + c8 - d8 will show in h8. I imagine it would
look something like the balance column in a petty cash journal, or something
similar.
 
-----Original Message-----
I'm trying to apply the following formula to cell h8:
=sumif(c8:d8, >0, f7 + c8 - d8)
My aim is if cells c8 & d8 = 0 they remaine blank. If a value is entered in
either c8 or d8, the sum of f7 + c8 - d8 will show in h8. I imagine it would
look something like the balance column in a petty cash journal, or something
similar.
Click to expand...
It appears that the sumif function is looking for a range
if the argument is true, that is you do not appear to be
able to us a formula referencing specific cells. I would
suggest restating the formula as follows if possible
=IF(SUM(C9:D9)>0,F7+C9-D9,"")
Regards
Chad
 
Back
Top