Request a formula!
 

Hey all, I've tried a while to get this working. SUMIF() is where I was
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 daily
the difference in the Projected & Actual income totals. i.e. B17 $5.00
+ C17 -$10.00. Only doing the calculation whenever I enter something
into any of the "ACTUAL" named boxes. Not calculate any days that have
$0.00 in all the actual boxes.

Example:

On September 3rd, once I've entered the actual boxes data. The big box
adds B17 + C17 + D17 and that's it. It doesn't continue to E17 because
all the actual boxes have $0.00 in them.


I hope I made sense



Thanks All
Craig


--
IcoHolic
------------------------------------------------------------------------
IcoHolic's Profile: http://www.excelforum.com/member.php...o&userid=37829
View this thread: http://www.excelforum.com/showthread...hreadid=573828

Request a formula!
 

The obvious limit is that actuals can not be 0, otherwise what is the
logic of selecting a value Since 0 could appear this is a danger, but
not withstanding as per your instructions

=SUMIF(B16:AB16,"<0",B17:AB17)

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=573828

Request a formula!
 

I have no idea what you just said. Everything seems to work exactly as I
wanted.


Thanks so much,
Craig


--
IcoHolic
------------------------------------------------------------------------
IcoHolic's Profile: http://www.excelforum.com/member.php...o&userid=37829
View this thread: http://www.excelforum.com/showthread...hreadid=573828

Request a formula!
 

For the formula to work as you requested, if there is a day which has no
actual expenses incurred, it would not be summed in your formula

eg day projected Actual
1 5 5
2 7 8
3 8 0
4 9 5


In the above example if the actual column is up to date the formula
will not sum for day 3 as there has been no actual cost as the 0
appears the same as for 0's for days in the future.


But it is what you requested


Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=573828