Question About A Formula

[Guest]

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.

 

[Chip Pearson]

I'm not clear what you're after, but try looking at the SUMIF or
COUNTIF functions.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

message
news:[email protected]...

 

[Guest]

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

Clay

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(A1:A99="Type 1"),A2:A100)

 

[Guest]

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

 

[Aladin Akyurek]

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

=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

 

[Guest]

Thanks worked like a charm.

Clay

=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.