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
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Can’t access settings for a few days lock out
Rak7 -
HelpiOS -

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

2 responses
calculating fuel surcharge
Nancy -
xpcman -

1 response