Support Board
Date/Time: Thu, 28 Nov 2024 05:40:40 +0000
Post From: Sumproduct with Multiple Criteria
| [2019-01-05 19:49:48] |
| eaglefutures - Posts: 48 |
|
Hello Support I'm having difficulty in getting this formula to work, could you please assist with the syntax. Have tried multiple options based on what i could dig up on the forum with little success. All the options which I have tried 1) =sumproduct(--(A2:A65)>13,--(A2:A65)<21) 2) =sumproduct((A2:A65)>13*(A2:A65)<21) 3) =sumproduct((A3:A66>13)*(A3:A66<21)) |