Question About A Formula

C

Clay Barks

I am working on a spreadsheet and have no idea how to set up this formula.

Given:
Line A - Type 1, Type 2, Type 3 Resources (example, cell A1=1, Cell A2=1,
Cell A3=3, Cell A4=2...100 entries long)
Line B - Quantities of above types

What I need to do is add the quantities for all Type 1, resources.

I am fairly knowledgeable in excel but can't think of the formula to do this
without making it so long it is unmanageable.
 
C

Clay Barks

The problem I am having is that I want to count the second line if the first
line meets my qualifiers.

Clay
 
C

Clay Barks

Well actually I want to count specific cells in line B if the corresponding
cells in line A meet my qualifiers.
 
A

Aladin Akyurek

Clay said:
Well actually I want to count specific cells in line B if th
corresponding
cells in line A meet my qualifiers.
Click to expand...

=SUMIF($A$2:$A$20,E2,$B$2:$B$20)

where E2 houses a type number, would sum (add up) all values in
whenever column A cells are equal to E2.

If this is not what you're looking for, try to give an example alon
with the expected result
 
C

Clay Barks

Thanks worked like a charm.

Clay

Aladin Akyurek said:
=SUMIF($A$2:$A$20,E2,$B$2:$B$20)

where E2 houses a type number, would sum (add up) all values in B
whenever column A cells are equal to E2.

If this is not what you're looking for, try to give an example along
with the expected result.
Click to expand...
 
Top