| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rolling Monthly Amounts to Annual Monthly Amounts | Excel Discussion (Misc queries) | |||
| Monthly NPV | Excel Worksheet Functions | |||
| How do I set up monthly random work schedule for 60 hours monthly | Excel Discussion (Misc queries) | |||
| Mortgage template comparing interest pd, monthly, bi-monthly, ext. | Excel Discussion (Misc queries) | |||
| Using NPV Monthly | Excel Worksheet Functions | |||
Linear Mode
