More help needed :-(

C

ChrisMattock

Hi again all, excel heavy day today Im afraid...

I have a spreadsheet with two columns, A and B...

Column A is one of three states, "None", "Medium" or "High"
Column B is a value, i.e. £1,200.00

I need three totals at the bottom;

1. For every row with "None" in column A, I need it to add up th
values from column B.

2. For every row with "Medium" in column A, I need it to add up th
values from column B.

3. For every row with "High" in column A, I need it to add up th
values from column B.

So an example result would be.... and ideas?

None 123000
Medium 9900
High 200
 
O

oteixeira

Hi
Supposing your range of data is A2:B12, enter the following formula:

=SUMIF(A2:B12,"None",B2:B12)

Repeat it for “Medium” and “High”

Hope it help
 
S

Stefi

Hi Chris,

Say your data rows go from 2 to 9, then in

A10: None B10: =SUMIF(A2:A9,A10,B2:B9)
A11: Medium drag down to B12
A12: High


Regards,
Stefi

„ChrisMattock†ezt írta:
 
D

Dav

Stefi should have made the ranges absolute

None B10: =SUMIF(A2:A9,A10,B2:B9)

should become sumif(a$2:A$9,a10,b$2:B$9)

Regards

Dav
 
Top