Excel 2007 : SUMIF Problem

**HarrBhatt08** · 12-08-2010, 05:16 PM

Hello everyone, I want to find the value of a (Row C) with multiple values from a dates (Row A) and product information (Row B) to be displayed in D1 as a total with all the dates, for example:

A B C D
1 Date Product Profit Total
2 1/12/2010 Aluminium £300.00 ?
3 1/12/2010 Aluminium £400.00
4 2/12/2010 Aluminium £500.00
5 2/12/2010 Aluminium £300.00
6 3/12/2010 Aluminium £400.00
7 4/12/2010 Aluminium £350.00

Can somebody help me with this please.

Thanks

**alansidman** · 12-08-2010, 08:15 PM

Place the date you wish to accumulate data on in cell F1. In cell F2 place the product name you wish to accumulate the sums for.

In D1, put this formula in =sumproduct(--(A2:A7=F1),--(B2:B7=F2),C2:C7)

Alan

**ConneXionLost** · 12-08-2010, 08:22 PM

Or you could try a pivot table.

**HarrBhatt08** · 12-09-2010, 05:22 AM

Originally Posted by alansidman

Place the date you wish to accumulate data on in cell F1. In cell F2 place the product name you wish to accumulate the sums for.

In D1, put this formula in =sumproduct(--(A2:A7=F1),--(B2:B7=F2),C2:C7)

Alan

Hello
I made a slight omission in the original problem, I need the total to calculate all the dates from Row A.

Can you advise what this formula would be.

Thanks

**alansidman** · 12-09-2010, 09:27 AM

You do mean Column A? Right?

=SUMIF(B:B,"Aluminium",C2:C7) or as ConneXionLost says, create a pivot table and filter it on the product.

See example of pivot table attached

**HarrBhatt08** · 12-09-2010, 07:31 PM

Hi Alan
Thank you for your second reply, very much appreciated but it still isn't working, I can't use the Pivot table, there isn't the room to display this, can you enter the formula in the example sheet uploaded and send back to me, this is very similar to what is required within the main worksheet and only has one cell available for this information to be displayed in.

Thanks again

Russ