Conditional Sum

[hhammash]

Hi,

I have a spreadsheet for materials with categories, I want to assign cells for totals for each category.


Example:

Vidoe --> Category 1
Cassette --> Category 2
Audio ---> Category 3

In column A I have the categories
In column B I have the description (video, cassette, audio ..etc)

I have 8 categories (items). How can I set a cell for each category to automatically sum the value of the respective category.

In cell F 2 I want to have the totals of Video, G 2 of Cassettes ..etc.

How can I put a formula in Cell F2 for instance to look for all the categories of 1 and sum them in that cell?

Thank you in advance

 

[lenze]

Why a formula. just use a Pivot Table.
But the formula would be
=COUNTIF($A$1:$A$10,"Category 1").
But, you said Sum. Are there numbers to be Summed?

lenze

 

[hhammash]

Hi Lenze,

Yes, there are numbers to be summed. It is about purchasing items. Whenever I purchase a Video I put "1" as a value under category, then the price of the video.

I want to sum all the prices when the category is "1" .

Thanks

 

[hhammash]

Re: Conditional Sum (SOLVED)

Hi,

Solved.

I tried Sumif as follows:
=SUMIF(A2:A15,"=1",B2:B15)

It worked as required.

Thank you Lenze

 

[wigi]

This is enough if column A contains numbers:

=SUMIF(A2:A15,1,B2:B15)