Monthly Expindature

[Guest]

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

 

[Don Guillett]

Have a look in the help index for SUMIF