sobrien1234
Board Regular
- Joined
- May 10, 2016
- Messages
- 175
- Office Version
- 365
- Platform
- Windows
In column E I have list of numbers but some of them are blank. i want tithe averagif to exclude the blank cells in column E and just average the cells with numbers in them.
=AVERAGE(IF(Sheet3!$B$3:$B$5000=$B3,Sheet3!E$3:E$5000))
thanks
Seamus
=AVERAGE(IF(Sheet3!$B$3:$B$5000=$B3,Sheet3!E$3:E$5000))
thanks
Seamus