| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
exclude amount from sumif total based on how many months
I need to exclude $$$ amounts from a sumif total based on how many months it
has been in service. Current formulas is: =SUMIF(M4:M23,"JJ",J4:J23) I need it to scan a different column for how many months and anything over 9 it will not add to the total. Thanks. V.XIII |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
exclude amount from sumif total based on how many months
=SUMPRODUCT(--(M4:M23="JJ"),--(N4:N23<=9),J4:J23)
where N4:N23 is the extra range you want to test for 9 -- Regards, Peo Sjoblom "Vercingetorix.XIII" wrote in message ... I need to exclude $$$ amounts from a sumif total based on how many months it has been in service. Current formulas is: =SUMIF(M4:M23,"JJ",J4:J23) I need it to scan a different column for how many months and anything over 9 it will not add to the total. Thanks. V.XIII |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF Exclude Certain Cell | Excel Worksheet Functions | |||
| total amount based on selections of 1-9, 10-19 and 20-30 | Excel Discussion (Misc queries) | |||
| How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
| sumif-add amount to another cell based on two criteria | Excel Discussion (Misc queries) | |||
| How do I calculate Amount of Sales Tax from Total Amount? | Excel Worksheet Functions | |||
![Vercingetorix.XIII[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
