Thread: Conditional sum

Hello there.

I gotta little problem here.
I want to add the values in a range of columns when the conditions are met in two different columns. Only values of the corresponding rows are to be added. For eg. if I have years in one column and months in the second column, I would like to know the expenses under various heads corresponding to purchases, tips, cartage etc, (listed under such columns as named) to be summed up and displayed as expenditure value for that month and year. I have data for about 12 years to be sorted out. Please help.

Can you please post a sample workbook for a look.

acsishere.

Thanks acsishere

I'm attaching the sheet with this msg. I need to add the values of cells in columns D to H when the month and year match the criteria of A & B.