Conditional Sum in Excel 2007

S

Srinivasulu B

I am using Excel 2007
Is it possible to display the sum of certain cells (in the same column)
based on some criteria.
I can explain my requirement as under.
Column A contains dates (from 1st Jan 2008 to 31st Decd 2009). This column
is formatted for date.
Column B contains amount spent on that date (Formatted for currency)
In column C, I want in C 31, the sum of the cells from B1 to B31, money
spent in January.
Similarly I want the sums corresponding sums of that month on the last day
of each Month.
Is it possible?
seena
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top