Need Formula that Works

R

Roberta

I have this worksheet with the below info. I'd like a formula that would find Other, take the amounts add them and then average them. Is an if statement. I selected Use or allow lables but when I do the formula it only dispalys the last amount from other. In cell B8 is where the results should be displayed.
A B
1 Type Amount
2 Other 526
3 New 245
4 New 147
5 Other 123
6 Other 254
7 New 145
 
J

Jason Morin

One way:

=SUMIF(A2:A7,"Other",B2:B7)/COUNTIF(A2:A7,"Other")

HTH
Jason
Atlanta, GA
-----Original Message-----
I have this worksheet with the below info. I'd like a
Click to expand...
formula that would find Other, take the amounts add them
and then average them. Is an if statement. I selected
Use or allow lables but when I do the formula it only
dispalys the last amount from other. In cell B8 is where
the results should be displayed.
 
F

Frank Kabel

Hi
try the array formula (entered with CTRL+SHIFT+ENTER):
=AVERAGE(IF(A1:A10="Other",B1:B10))


--
Regards
Frank Kabel
Frankfurt, Germany

Roberta said:
I have this worksheet with the below info. I'd like a formula that
Click to expand...
would find Other, take the amounts add them and then average them. Is
an if statement. I selected Use or allow lables but when I do the
formula it only dispalys the last amount from other. In cell B8 is
where the results should be displayed.
 
Top