using Sumif to sum particular values from a data table

[deante]

Hello All,

I am trying to sum cells that are in a table based on criteria from a different column. Here is an example of what my data looks like.

Tech Day
A 15
B 20
B 10
C 55
B 20
A 25
B 25

I want to sum the day values based on a particular Tech type. For example, I want B to total 75, I tried a combination of sumifs, index and vlookup.

Thanks In Advance

D

 

[xlbo]

why a combination??

=SUMIF(A2:A10,"B",B2:B10)

where names in col A and values in col B

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[bluedragon2]

=SUMPRODUCT((a2:a10="B")*(B2:B10))

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[Rofeu]

Sounds like a job for a pivottable.

Cheers,

Roel

 

[ThomasLafferty]

Hi there! If you want a nice flexible way of investigating data on the fly, try this:

1. Click anywhere in your list and apply a data filter
Data>Filter>Autofilter
2. Filter your list for any Tech.
3. Below the last data item in your Day column, below the
last blue row, click your autosum button and press
enter.
4. You may now filter and get different totals as you wish
for each tech.

Hope this helps...
Tom

Live once die twice; live twice die once.

 

[xlhelp]

Couple more

1. Sort the data by column A and use Subtotal under Data.

2. Highlight the entire range, give it a name (for ex. tekdys)

go to a blank cell. Under Data, select Consolidate. Choose Function to be SUM. Under reference type tekdys and put check marks for use labels in Top Row and left column. Click Ok

(This assumes the data has label in the top row)

Me transmitte sursum, Caledoni!

 

[deante]

Sorry it took so long for me to get back, I used xlbo's tip and it worked great thanks for everyones help!