Help me with this

[Sasikiran]

Hi,

I need a formula to calculate the total transactions done for a particular
day.

Its better to explain you with an example. Lets say there is a range of
cells A110 where the column A has dates and column D has values pertaining
to that date.

I need a formula to count the total transactions for that particular date.
The formula should check the range A1:A10 and look for that particular date
and take the corresponding value from the same row in the range D110.

A B C D
9Jan 10
9Jan 5
6Jan 1
7Jan 2
9Jan 6

Here the total value of 10, 5 & 6 should get added in a particular cell by
looking at the date.

Thanks in advance

 

[JE McGimpsey]

Take a look at SUMIF() in XL Help.

Also, if you need to sum ALL dates, consider a Pivot Table.

 

[CLR]

=SUMIF(A:A,"1/9/08",B:B)

Vaya con Dios,
Chuck, CABGx3

 

[Sasikiran]

Thanks a lot

=SUMIF(A:A,"1/9/08",B:B)

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

Happy to help..........thanks for the feedback.

Vaya con Dios,
Chuck, CABGx3