Average Function

[ToledoTom]

I can't make this function work the way we need. This is for therapists in a hospital. Sometimes, staff members work in different departments, and sometimes they have students. We collect certain data everyday, and it needs to be averaged correctly for some info that we need. We've used =sum (data)/counta(data) to give me my weekly average. The student and therapist, while they have separate data, need to be counted as one. I thought I could just use parentheses to accomplish this, but I can't.
So, in my pic I'm attaching, I need the "AF" and "S" data to be counted as 1. So they need to be added together. Both monday and tuesday in this case equals 45.

Another way to say this is: I need the weekly average column to only count the data in the cells with data in them, AND with the caveate of; if there's data in the "S" column, that needs to be combined with the "AF" cell and count as a whole.
Please advise.

 

[Eric W]

Regrettably, your picture is too small to show necessary details, and when I tried to enlarge it, it just got blurry. You might want to look into the XL2BB add-in, which makes it much easier to show your example, and much easier for helpers to work with it. Look at the link in my signature, or in the reply box.

But if I understand your question correctly, you might not need to do anything too fancy. For example:

Book1
	P	Q	R	S	T												AF
1
2	10
3				10													8
4				11
5				5													19
6
7				7
8
9
10
Sheet7

Cell Formulas
Range	Formula
P2	P2	=AVERAGE(S2:S10,AF2:AF10)

The AVERAGE function already ignores empty cells. So you can just use it like above, and get the average of any values in the S and AF columns.

 

[MARK858]

You might want to look into the XL2BB add-in

From the OP's other posts they are using Google Sheets

 

[Eric W]

From the OP's other posts they are using Google Sheets

I suspected as much from the forum and that he said "Web" for the platform. But he also said "Windows", so there's the possibility he can use XL2BB. But either way, the picture he posted is not very useful, and I wanted to mention that.

I'm also not entirely sure that AVERAGE works the same in Google Sheets, but I think so.

 

[MARK858]

I'm also not entirely sure that AVERAGE works the same in Google Sheets

Syntax is the same

 

[Joe4]

ToledoTom,
More than just posting the questions to the "General Discussion & Other Applications" forum, since this covers ALL other programs (and not just Google Sheets), if your questions are indeed about Google Sheets, be sure to explicitly and clearly state that in either the thread title or the original post of each question/thread, so there is no confusion there.

Thanks.
The Moderators