get value dependant on multiple columns!

[burgensteen]

Hi all, This is my first post so I apologize if this is the wrong room or i am not explaining myself very well.

I have a sheet with (for example):

Date-------- Description---Income---Balance
01/01/2001--Work---------100.00----100.00
02/01/2001--Parts---------50.00-----150.00
02/01/2001--Work---------25.00-----175.00
---------------------------TOTAL----xxx.xx

I need the TOTAL cell to be defined by:
Adding up 'Income' from cells between date (defined by me) and (defined by me) with only description 'Work'

Thanks for any help you could give me in regards to this.

[davesexcel]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[benishiryo]

hi burgensteen, welcome to the forum. assuming your data is in A2:D10, in that order you illustrated, then:
=SUMPRODUCT((A2:A10>=--"1jan2001")*(A2:A10<=--"31jan2001")*(B2:B10="Work"),C2:C10)

change the dates to what you need. if you refer it to a cell reference like G1 & H1, then:
=SUMPRODUCT((A2:A10>=G1)*(A2:A10<=H1)*(B2:B10="Work"),C2:C10)

next time though, attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[burgensteen]

WOW...Thank you for the fast replies and my apologies for not posting a sample doc (will remember for future posts).
I shall go try the formula and let you guys know.

Thanks again.
Jon

[burgensteen]

Thank you for the help.
The help you gave worked a treat