Maybe an IF ??

[kaplonk]

If I have a page with one column as date format and another column a
values and it runs throughout the year, can I have a cell that ca
summarises that data, such as one that calculates monthly totals wher
it gets the date purely from the date format dd/mm/yyyy ? (I'm English

 

[mzehr]

Hi,
Assuming that your dates are in column A (rows 2-100), and
the Data values are in column B try the following:
=SUMPRODUCT(--(YEAR(A2:A100)=2004),--(MONTH(A2:A100)
=1),B2:B100). Change the month number for the one you
want. One other way is to use a pivot table to summarize
the data for you, and have it group by month.


HTH

 

[Andy B]

Hi

Try summarising using a pivot table (Data / Pivot Table). This is what they
are designed for. For an intro, visit here:
http://peltiertech.com/Excel/Pivots/pivotstart.htm

You can set the dates to summarise into days, quarters, months, years and
more.

 

[kaplonk]

If I do this, in the summary cell:
=IF(MONTH(A2)=1,(B2),0)
it only checks one cell for one month then puts the figure next to i
in the january summary cell.

How does excel handle loops?

How would I loop through all the entries checking each for a specifi
month then adding the value together?

What is excel for += ?


Help! Beginner Excel user

 

[kaplonk]

thanks mzehr.

that worked beatifully.


I posted my previous reply before I saw yours