=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