Previous Topic Next Topic

How to calculate the average of a range day by day?

Closed
jutulu Posts 34 Registration date Monday March 10, 2014 Status Member Last seen September 21, 2015 - Apr 1, 2014 at 01:55 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 8, 2014 at 10:59 AM
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 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Apr 8, 2014 at 10:59 AM
Hi Jutulu,

This sounds like a formula location issue.

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

Best regards,
Trowa
0

Similar discussions

You disagreed with the decision facebook
MDHamijuddin -
HelpiOS -

1 response
You Disagreed With the decision problem
SrikantaBadyakar -
HelpiOS -

1 response
decision ON 23 JULY 2021 It usually takes us just over a day to review your info
Raza -
SURAJ -

2 responses
Hello sir back my Facebook account
razukhan01712437072 -
HelpiOS -

1 response
You disagreed with the decision
AjayChand -
HelpiOS -

1 response