Support Board
Date/Time: Thu, 28 Nov 2024 05:47:15 +0000
Post From: Sumproduct with Multiple Criteria
| [2023-05-28 00:50:38] |
| user_xyz - Posts: 416 |
|
I am working on a sumproduct solution similar to original post would this work now? 1) =sumproduct(--(A2:A65)>13,--(A2:A65)<21)
Specifically I'm trying to evaluate a number if within range (this works in excel) =IF(SUMPRODUCT(--(AA3:AC3>=E3-4),--(AA3:AC3<=E3+4))>0,1,0) SC mentions in post #2 definitely not supported work with available functions. Sumproduct is listed so unsure if sumproduct was added AFTER 2019 or the formula with the double unary operators will not work. Date Time Of Last Edit: 2023-05-28 01:02:39
|