Support Board

Date/Time: Wed, 15 May 2024 15:31:02 +0000

Post From: Search columns for multiple criteria

[2018-08-17 14:04:03] Link To Thread - Link To Post [Go To First Post]
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 - 236 views