serchingcell
New member
- Joined
- Oct 31, 2011
- Messages
- 3
- Reaction score
- 0
- Points
- 0
Hi,
This is my first thread and im new to excel I’m using below formula to result weekday average and its returning with average include blank cells. I’m not sure how to add "exclude blank cells" formula in this. But i want it to count the cells contain “0” as value.
=SUMPRODUCT((WEEKDAY($A$4:$A$26,2)<6)*B4:B26)/SUMPRODUCT((WEEKDAY($A$4:$A$26,2)<6)*1)
Please help...
This is my first thread and im new to excel I’m using below formula to result weekday average and its returning with average include blank cells. I’m not sure how to add "exclude blank cells" formula in this. But i want it to count the cells contain “0” as value.
=SUMPRODUCT((WEEKDAY($A$4:$A$26,2)<6)*B4:B26)/SUMPRODUCT((WEEKDAY($A$4:$A$26,2)<6)*1)
Please help...