Hello All
I'm having issues with AVERAGE IF.
I have the code:
Where B5:B133 is a column with dates from 12-7-2021 to 12-10-2021
"=B5" is a date of 12-7-2021
J5:J133 is a column of numbers
What I want, is if 12-7-2021 is found in column B, then all the numbers associated with the date of 12-7-2021, or averaged from column J. However, I keep getting a #DIV/0! error.
What am I doing wrong?
Thanks for the help
I'm having issues with AVERAGE IF.
I have the code:
VBA Code:
=AVERAGEIF(B5:B133,"=B5",J5:J133)
Where B5:B133 is a column with dates from 12-7-2021 to 12-10-2021
"=B5" is a date of 12-7-2021
J5:J133 is a column of numbers
What I want, is if 12-7-2021 is found in column B, then all the numbers associated with the date of 12-7-2021, or averaged from column J. However, I keep getting a #DIV/0! error.
What am I doing wrong?
Thanks for the help