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 A1:D10 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 D1:D10.

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

Take a look at SUMIF() in XL Help.

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

In article ,
Sasikiran wrote:

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 A1:D10 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 D1:D10.

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

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

Vaya con Dios,
Chuck, CABGx3



"Sasikiran" wrote:

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 A1:D10 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 D1:D10.

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

Thanks a lot

"CLR" wrote:

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

Vaya con Dios,
Chuck, CABGx3



"Sasikiran" wrote:

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 A1:D10 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 D1:D10.

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

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

Vaya con Dios,
Chuck, CABGx3



"Sasikiran" wrote:

Thanks a lot

"CLR" wrote:

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

Vaya con Dios,
Chuck, CABGx3



"Sasikiran" wrote:

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 A1:D10 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 D1:D10.

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