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 Contributor 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 Contributor 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

Similar discussions

You disagreed with the decision facebook
MDHamijuddin -
HelpiOS -

1 response
Can’t access settings for a few days lock out
Rak7 -
HelpiOS -

1 response
You disagreed with the decision
AjayChand -
HelpiOS -

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

1 response
Hello sir back my Facebook account
razukhan01712437072 -
HelpiOS -

1 response