Excel: Change current formula to count and average

Experts:

I have a formulas that I need to have modifies into a "count" and one formula for an "Average". This is the current formula below

=OFFSET('Executive Rollup Data'!BP60,0,MATCH(TODAY(),'Executive Rollup Data'!BP60:$DT60)-2,1,1)


Thoughts?

Thanks experts!
Maliki HassaniAsked:
Who is Participating?
 
barry houdiniConnect With a Mentor Commented:
Hello LANCE,

that formula simply defines a range, it doesn't do anything with it....

If you want to AVERAGE the values in the range you can enclose it in an AVERAGE function, i..e

=AVERAGE(OFFSET('Executive Rollup Data'!BP60,0,MATCH(TODAY(),'Executive Rollup Data'!BP60:$DT60)-2,1,1))

and you can do the same with COUNT, i.e.

=COUNT(OFFSET('Executive Rollup Data'!BP60,0,MATCH(TODAY(),'Executive Rollup Data'!BP60:$DT60)-2,1,1))

COUNT just counts numbers, if you want to count any entries (numeric or text) switch to COUNTA

regards, barry
0
 
barry houdiniCommented:
.....actually, I'm talking rubbish (wouldn't be the first time)

The OFFSET function is only giving you a single value so it won't make much sense to AVERAGE or COUNT that, can you explain what you want to do in a little more detail

regards, barry
0
 
Maliki HassaniAuthor Commented:
Your first anser helped thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.