Have a look in the help index for SUMIF

--
Don Guillett
SalesAid Software

"Anthony" wrote in message
...
Hi
I am having a slight memory block with this, I know its easy but can't
remember how to do it.

Column A is populated with dates in formatt dd mmmm yy eg 10 March 07
Column G is populated with invoice amounts as £0.00


can somebody put me out of my misery and advise who to search down column
A
for a date eg 10 March 07 and total all the cells found through column G
If possible the formula should be able to be dragged down so that I can
tally up each seperate day of the month easily