I ran into another excel problem I could use some help with.
Here's a simplified version of what I'm having problems with:
Code:
A1 - 5 B1 - 10 C1 - x
A2 - 5 B2 - 10 C2 - x
A3 - 5 B3 - 10 C3 - x
A4 - 15 B4 - 30 C4 - D4 - 22.5
A4, B4, and C4 will be where I enter the SUM formula to total the cells above them. The problem I have is I need the cell in C4 to be blank if there are no numbers entered in C1:C3. Even though I want the cell to look blank if there are no numbers to total, I need the formula to be in there so when numbers are entered it will automatically calculate the total and show that total.
I then need to average the totals in A4, B4, and C4. I only want to average totals with numbers (so I am using an AVERAGEIF formula). In the example above, it should only average A4 (15) and B4 (30) for an average of 22.5. Then as soon as numbers are entered in C1:C3, I'd like the total to automatically show in C4 and then also automatically be included in the average shown in D4.
The problem I am having is that whatever formula I use in A4, B4, and C4 to total those cells up, it will show a 0 if there are no numbers in the cells above them. If there is a 0 result, then my averageif formula will include this 0 in the average amount in D4.
(Some sums in A4, B4, C4 might actually be 0 so for those instances, that 0 result should be included in the averages)
Whew...I hope I explained that well enough to understand
Anyone have any idea to accomplish what I need?
Thanks!