andrewb90
Well-known Member
- Joined
- Dec 16, 2009
- Messages
- 1,077
Hello everybody,
I seem to have once again attempted to write a formula that was beyond my current skill level, and I need some assistance.
In the Cells B9,B11,B13,B15,and B17 I have this formula(well the cell refs are different):
In B19 I am trying to get an average of the five cells, but only if they have data in them. i was figuring some sort of nested if would work, but I haven't had any luck.
The only useful part about the data is that each cell would fill up in order (as they represent five consecutive weeks) meaning that B9 could have number and none of the others would but that wouldn't be the case for B13 (if B13 had data then 9 & 11 would have data at least)
I hope I am making enough sense for somebody to help me.
Regards,
I seem to have once again attempted to write a formula that was beyond my current skill level, and I need some assistance.
In the Cells B9,B11,B13,B15,and B17 I have this formula(well the cell refs are different):
Code:
=IF(B22>0,B22,"-")
The only useful part about the data is that each cell would fill up in order (as they represent five consecutive weeks) meaning that B9 could have number and none of the others would but that wouldn't be the case for B13 (if B13 had data then 9 & 11 would have data at least)
I hope I am making enough sense for somebody to help me.
Regards,