Marklarbear
Board Regular
- Joined
- Nov 6, 2003
- Messages
- 112
- Office Version
- 365
- Platform
- Windows
Hi guys
I have the following array formula which works a treat for me:
{=AVERAGE(IF(WEEKDAY($O$4:$O$34)=6,$P$4:$P$34))}
(averages Fridays within a given date range)
What I want to do now is to modify the formula to exclude any Friday that has a 0 value or no value at all..... I'm thinking it's an "AVERAGEIF" but I'm struggling to crack it...
As always - any help is greatly appreciated!
I have the following array formula which works a treat for me:
{=AVERAGE(IF(WEEKDAY($O$4:$O$34)=6,$P$4:$P$34))}
(averages Fridays within a given date range)
What I want to do now is to modify the formula to exclude any Friday that has a 0 value or no value at all..... I'm thinking it's an "AVERAGEIF" but I'm struggling to crack it...
As always - any help is greatly appreciated!