Monthly Expindature
 

Hi
I download Bank statement every month. I want to know if there are withdraws
4 times a month it should show me 1 withdrawl and total , same if i make
deposits it should show me deposit only once

my data is
Date Description Amount Running Bal.

1/2/2007 MIDDLESEX WATER Bill Payment -148.47 6378.85
1/4/2007 Counter Credit 887.82 7266.6

Any help is really appreciated.

Thanks

Nisha P

Monthly Expindature
 

Have a look in the help index for SUMIF

--
Don Guillett
SalesAid Software

"nishkrish" wrote in message
...
Hi
I download Bank statement every month. I want to know if there are
withdraws
4 times a month it should show me 1 withdrawl and total , same if i make
deposits it should show me deposit only once

my data is
Date Description Amount Running Bal.

1/2/2007 MIDDLESEX WATER Bill Payment -148.47 6378.85
1/4/2007 Counter Credit 887.82 7266.6

Any help is really appreciated.

Thanks

Nisha P