Guinaba
Board Regular
- Joined
- Sep 19, 2018
- Messages
- 218
- Office Version
- 2016
- Platform
- Windows
Hi guys,
I am using the below formula to sum up all the rows on col. K based on the condition "Green", however if I try to add another condition say...--($M$62:$M$1056="Square") keeping both in the formula, the formula doesn't work. Any suggestion?
Ok =SUMPRODUCT(SUBTOTAL(109,OFFSET(K$62,ROW(K$62:K$1056)-ROW(K$62),,1)),--($J$62:$J$1056="Green"))
Not ok =SUMPRODUCT(SUBTOTAL(109,OFFSET(K$62,ROW(K$62:K$1056)-ROW(K$62),,1)),--($J$62:$J$1056="Green"),--($M$62:$M$1056="Square"))
Cheers
I am using the below formula to sum up all the rows on col. K based on the condition "Green", however if I try to add another condition say...--($M$62:$M$1056="Square") keeping both in the formula, the formula doesn't work. Any suggestion?
Ok =SUMPRODUCT(SUBTOTAL(109,OFFSET(K$62,ROW(K$62:K$1056)-ROW(K$62),,1)),--($J$62:$J$1056="Green"))
Not ok =SUMPRODUCT(SUBTOTAL(109,OFFSET(K$62,ROW(K$62:K$1056)-ROW(K$62),,1)),--($J$62:$J$1056="Green"),--($M$62:$M$1056="Square"))
Cheers