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
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
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:
- How to calculate the average of a range day by day?
- Time of day clock stopped - Guide
- Hay day download pc - Download - Simulation
- You can't access certain settings for a few days - Instagram Forum
- How to calculate position in excel ✓ - Office Software Forum
- How to calculate position (1st,2nd,3rd) in excel....? - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 8, 2014 at 10:59 AM
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
This sounds like a formula location issue.
Besides that, your if statement is always true, which makes it unnecessary.
Best regards,
Trowa
