i please need a formula to give a result based on data in two separate columns

[thumper64]

Hi all,

tried for 3 days but just can't crack this one.
i have a table with column headings DATE, EXPENSE,AMOUNT with a drop down menu on the expense column listing fuel,insurance,maintenance etc. then i manually enter the amount.

Away from the table i need to total items purchased
Between certain dates AND Type of expense.

eg Fall between Jan1st to March31st AND says "fuel" in the expenses column.= ????

Fall between Jan1st to March31st AND says "insurance" in the expenses column= ????

Fall between Jan1st to March31st AND says "maintenance" in the expenses column=????


I hope this makes sense

Thank you in anticipation

thumper64 (phil) <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->

 

[AlphaFrog]

If you have Excel 2007 or later, you could use the SUMIFS function e.g.

=SUMIFS(C:C, A:A, ">="&DateValue("1/1/2010"), A:A, "<="&DateValue("3/31/2010"), B:B, "Fuel")

IF you have Excel 2003 or earlier, Use the SUMPRODUCT function...

=SUMPRODUCT((C1:C100)*(A1:A100>=DATEVALUE("1/1/2010"))*(A1:A100<=DATEVALUE("3/31/2010"))*(B1:B100="Fuel"))

 

[thumper64]

SOLVED .... i please need a formula to give a result based on data in two separate columns

Thank you you are a genius!!! quick too!!

thumper64 (phil)