[suspectx0]

I am trying to make a spreadsheet that will take a date and see that it has a specific dollar amount to it for a specific type of product.
IE lets say I want to see how much I spent in January on bagels.
I know how to count how many times I bought bagels in July using sum product but I want to knowhow I can add the dolllar amount.
My spreadsheet would have a date column, a collumn for what I buy and a collumn for the price I paid for it.
This is what I tried to use but I have no luck with it.
=SUMPRODUCT((MONTH(Date1)=1)*Ifoodtyp1)*(foodcost1 ="Bagel")
Any help would beg reatly appreciated

[JBeaucaire]

I think the formulas you really want to use are COUNTIF() and SUMIF(), though you can certainly DO the job with SUMPRODUCT().

If you post up a sample spreadsheet with a spot showing your desired RESULTS, this will be much simpler to resolve for you. In the sample, do not try to fake formulas, just manually enter the results the way you want them shown in your layout.

So mockup a sample workbook showing the dilemma then click GO ADVANCED and use the paperclip icon to post up your workbook.

[JBeaucaire]

Strictly off the SUMPRODUCT() approach, I would say the syntax would be:

=SUMPRODUCT(--(Month(DateRange)=1),--(FoodRange=Food1),FoodCostRange)