How to calculate the average of a range day by day? [Closed]

Report
Posts
34
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 21, 2015
-
Posts
2669
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 15, 2020
-
Hi all,
How to calculate the average of a range day by day? A is the column for the day, and the average should go at the top of each day. I've done the countif but it brings results in every cell other than at the top of each day;

=IF(COUNTIF(A2192:A2192,A2192)=1,AVERAGE(BJ2193:$BJ$10000))

Much appreciated

1 reply

Posts
2669
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 15, 2020
446
Hi Jutulu,

This sounds like a formula location issue.

Besides that, your if statement is always true, which makes it unnecessary.

Best regards,
Trowa