SumIf

Hey guys, your forum has been an amazing help to me in the past and today i finallly decided to join.

I have an issue with SumIf. I know how to use it based on one condition and even based on two numerical conditionals, however i can not for the life of me get it to work based on a description and a date, see below. The data is a list of account transactions over the past 6 years and i dont want to have to manually add the cells up i need. What i am looking for is the total of col C, when Col A less than 31Jan 2012 and col B has the decription PP P & F LAZARUS.

Col A: Dates
Col B: Descriptions
Col C: Values

Would also be terrific if you could help with a date range as well. Something like add Col C when date is between 1.01.11 and 01.01.12 with the description.

I really hope this all make sense and that someone is able to assit. This has been driving me crazy!!

Cheers
L

Try this =SUMIFS(C2:C26,A2:A26,"<1/31/2012",B2:B26,"PP P & F LAZARUS").

Good luck!

Hi Deliguy, nope didnt work

Hey Guys,

Attached is a section of the spreadsheet. I am waiting to get a formula that i can apply to the whole spreadsheet to add the cells in column C highlighted in yellow, (they all all the same decription, which is given in column B)and between date ranges. The dates are in column A.

Does this make sense?