Maybe an IF ??

K

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
 
M

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
 
K

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
 
K

kaplonk

thanks mzehr.

that worked beatifully.


I posted my previous reply before I saw yours
 
Top