| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Exclude $ Amount from sum based on how many months its been
I need a formulas to exclude $$ Amounts from sumif based on how many months
its been in service, example current formulas is:=SUMIF(M4:M23,"JJ",J4:J23) but I need it to check another column and if it has been over 9 months, exclude that figure from the total. Any ideas???? I appreciate all the help I have been getting here. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| exclude amount from sumif total based on how many months | Excel Discussion (Misc queries) | |||
| Exclude Network Path In PivotTable Based on Sharepoint | Excel Discussion (Misc queries) | |||
| When Averaging a column, exclude value based on another cell value | Excel Worksheet Functions | |||
| How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
| How Do I Do an Exclude Filter based on a Named Range? | Excel Worksheet Functions | |||
![Vercingetorix.XIII[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
