Sum of the cell values depending on the data from other cell

**IamDBest** · 05-23-2007, 06:42 AM

I have following cell structure (Sample Data)

HTML Code:

I want the results to be displayed in another cell using formula as follows

HTML Code:

Which formula will give me this data dynamically?

**sweep** · 05-23-2007, 08:06 AM

Hi,

You can use the sumif function to do this:

=SUMIF(A1:A7,"=North",B1:B7)

**Jazzer** · 05-23-2007, 08:14 AM

Hi,

Attached is an Excel file with two different solutions. The first one (Sheet1) is less dynamic, but much simpler. There is only one formula, that aggregates the values, but you have to manually update the categories (North, South, East, West)

The next one (Sheet2) automatically picks up the categories from Column A and sorts them in the column F. In the Column E there is the same kind of formula as in Sheet1, but it is also a dynamic one. Meaning, you don't have to manually change the data area. Columns C and D are there to make the category sorting possible and can be hidden away.

- Asser

**mudraker** · 05-23-2007, 08:22 AM

IamDBest

Welcome to excelforum

Please read forum rules - see links below

Your thread is posted in the wrong forum, it sould be in the Excel Worksheet Functions forum

Excel Programming forum is for VBA macro type questions