Earlier today I posted this and had no responses~
It's difficult to believe that a forum filled with Excel experts don't have an answer...
Someone please supply the answer...
here's the original post...
I have designed a worksheet that tabulates all revenue and expenses for each truck in my small fleet over an entire year.
I use the IF formula to identify a date in the first column (A) to return a blank in the other columns to keep the worksheet clear of 0’s or #DIV/0! for cells to be used later in the year. This keeps the entire worksheet clear of any data until a date is entered in column A.
On a separate worksheet designed to tabulate the combined numbers for each of the 30+ trucks in my fleet, the IF formula no longer works in the manner I want.
Here is an example of the IF statement used on each of the worksheets in the group…
=IF(A10>40500,D10-E10," ") I have used similar statements in each column to keep the worksheet clean
This is the formula I attempted to use to tally these cells into a comprehensive worksheet total.
=IF(A9>40500,('405:410'!F10)," ")
Excel returns the following formula in the formula bar… =IF(A9>40500,('405:[410]410'!F10)," ")
And receive … #REF! in the cell where the formula was written.
I presently have the final worksheet set up to sum these figures BUT the worksheet is filled with 0’s and #DIV/0! When the sum formula is extended to the bottom of the worksheet.
Does anyone have a solution that would keep the final worksheet clean until a date is entered?
Bookmarks