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

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

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

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

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


"Anthony" wrote:

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

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

Ron,
just great - many thanks!

"Ron Coderre" wrote:

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


"Anthony" wrote:

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

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

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

--
Don Guillett
SalesAid Software

"Anthony" wrote in message
...
Ron,
just great - many thanks!

"Ron Coderre" wrote:

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


"Anthony" wrote:

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