willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 888
- Office Version
- 365
- Platform
- Windows
Hello,
It is my first time using the AverageIf function and I seem to be having trouble getting it to work.
I want the formula to calculate the average of all numbers in sheet "warranty report" column O that have a date of 2019 in column L. The sheet that the formula is on has the date of 2019 in cell B1.
=AVERAGEIF('Warranty Report'!O:O,B1,'Warranty Report'!L:L)
However this formula is giving me a #DIV/0! error.
Any help would be appreciated.
Thank you
Carla
It is my first time using the AverageIf function and I seem to be having trouble getting it to work.
I want the formula to calculate the average of all numbers in sheet "warranty report" column O that have a date of 2019 in column L. The sheet that the formula is on has the date of 2019 in cell B1.
=AVERAGEIF('Warranty Report'!O:O,B1,'Warranty Report'!L:L)
However this formula is giving me a #DIV/0! error.
Any help would be appreciated.
Thank you
Carla