Hey all, I've tried a while to get this working. SUMIF() is where I wa
trying. No dice though
Image of the spreadsheet:
http://www.icoholic.com/pics/exceltroubles.jpg
Problem:
In the area with the -$2,8525.00 number. I want it to calculate dail
the difference in the Projected & Actual income totals. i.e. B17 $5.0
+ C17 -$10.00. Only doing the calculation whenever I enter somethin
into any of the "ACTUAL" named boxes. Not calculate any days that hav
$0.00 in all the actual boxes.
Example:
On September 3rd, once I've entered the actual boxes data. The big bo
adds B17 + C17 + D17 and that's it. It doesn't continue to E17 becaus
all the actual boxes have $0.00 in them.
I hope I made sense
Thanks All
Crai
Dav - 21 Aug 2006 17:37 GMT
The obvious limit is that actuals can not be 0, otherwise what is th
logic of selecting a value Since 0 could appear this is a danger, bu
not withstanding as per your instructions
=SUMIF(B16:AB16,"<>0",B17:AB17)
Regards
Da
IcoHolic - 21 Aug 2006 18:24 GMT
I have no idea what you just said. Everything seems to work exactly as I
wanted.
Thanks so much,
Craig

Signature
IcoHolic