Easy Sumproduct or Sumif - but I can't remember how ..lol !

[Guest]

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

 

[Don Guillett]

Have a look in the help index for SUMIF

 

[Guest]

With
A2:A20 containing dates
G2:G20 containing amounts

Try something like this:
I2: (a date)

This formula sums the Col_G cells where the corresponding Col_A cell's value
equals the date in cell I2
J2: =SUMIF($A$2:$A$20,I2,$G$2:$G$20)

(Note: The dollar signs ($) in the formula "lock" the respective range
references so they don't change when the formula is copied down)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP

 

[Guest]

Ron,
just great - many thanks!

With
A2:A20 containing dates
G2:G20 containing amounts

Try something like this:
I2: (a date)

This formula sums the Col_G cells where the corresponding Col_A cell's value
equals the date in cell I2
J2: =SUMIF($A$2:$A$20,I2,$G$2:$G$20)

(Note: The dollar signs ($) in the formula "lock" the respective range
references so they don't change when the formula is copied down)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP

 

[Don Guillett]

Wouldn't it have been more rewarding had you looked in help and figured it
out yourself? Maybe not?