If Column A contains X and Column B contains 'Date', add Column C??

[Bellio3105]

Hi,

I've trying to work out monthly expenses for all staff, however each expense has to be put into the spreadsheet individually.

I currently have column A with employees name, Column B with date, and Column C with cost.

I've created a table on another worksheet with employee name along the top, and Monthly along the side.

I am able calculate total expenses for each employee by using 'SUMIF', but wanting to further split the expenses by month.

Am I able to do this?

Thanks,

Dan

[Bellio3105]

I think I didn't explain this well, sorry.

I have attached the document which also shows the table I want to populate. Hopefully this will help people understand better.

For example, I want all column C data added where column B is KD and column A is dated 01/08/2012- 31/08/2012.

Thanks,

Dan

[tigeravatar]

Dan,

Attached is a modified version of your provided workbook. In cell G2 and copied over and down to S13 is this formula:

Please Login or Register  to view this content.

Then in cell G14 and copied over to S14 is a simple sum formula:

Please Login or Register  to view this content.

Does that work for you?

[Bellio3105]

Tigeravatar,

That's exactly what I wanted, Thanks. Your help is greatly appreciated.

Dan

[tigeravatar]

You're very welcome