Support Board
Date/Time: Tue, 21 Jan 2025 12:23:05 +0000
[Programming Help] - Search columns for multiple criteria
View Count: 671
| [2018-08-17 14:04:03] |
| User345323 - Posts: 18 |
|
Hello, I'm trying to reproduce COUNTIFS excel function with spreadsheet. I need to reproduce this attached exemple. -------A--------B-------C 1---DATA1-----DATA2-----RESULT 2---10---------1----------2 3---5----------1----------3 4---7----------0----------0 5---5----------0----------2 6---3----------0----------0 7---4----------1----------1 8---10---------1----------1 9---5----------1----------2 10--6----------1----------1 11--5----------1----------1 *** I NEED TO SUM HOW MANY TIMES ON TWO COLUMNS I GET VALUE OF CELL A2 COMBINED WITH NUMBER 1, OR CEL A3 COMBINED WITH NUMBER 1 ... ... I CAN'T SEARCH THEM WITH IF AND THEN SUM THEM ON OTHERS COLUMNS BECAUSE COLUMN A CAN HAVE FROM 1 TO 100 VALUE AND CAN'T USE SOO MANY COLUMNS ANY SIMPLE WAY TO DO IT AS EXCEL DO IT WITH COUNTIFS? *** With old spreadsheet I get correct result with: =SUMPRODUCT((A2:A11 = A2) * (B2:B11 = 1)) but it's very CPU heavy for my computer. Thanks for the help. Regards Date Time Of Last Edit: 2018-08-17 16:46:24
|
 example.jpg / V - Attached On 2018-08-17 13:58:24 UTC - Size: 128.37 KB - 264 views |
| [2018-08-17 15:03:03] |
| User345323 - Posts: 18 |
|
Any solution Sierra Chart support? Tnx |
| [2018-08-18 10:24:06] |
| User345323 - Posts: 18 |
|
Up ... any help please? Thank you |
To post a message in this thread, you need to log in with your Sierra Chart account: