More help needed :-(

  • Thread starter Thread starter ChrisMattock
  • Start date Start date
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
 
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
 
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:
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to populate a cell with numeric value based on textselected from pull down in adjacent cell? 1
nested if statements - multiple variables 1
Scrabble Value calculation for Welsh words 0
Vlookup-Doesn't return values under 1 1
search function 2
Simple nested if and statement 2
Nesting countif functions 1
SUM Q 2

Back
Top