View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anthony Anthony is offline
external usenet poster
 
Posts: 275
Default Easy Sumproduct or Sumif - but I can't remember how ..lol !

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