0
I'm having some difficulty in figuring out a way to make this work in Google Sheets.
I'm looking to use a countif (or similar function) to count rows in a sheet where column B:B+C:C+D:D > sheet2!$A$2. The function should only count rows that match the criteria of sheet2!$B$3 within cell A:A, as well as a couple other criteria, with the same format, just different cells, so I assume a countifs is probably the best option?
My current approach is something similar to below (ive tried variations), but I can't seem to find a way to make it consider each row individually.
=countifs(sheet1!B:B+sheet2!C:C+sheet3!D:D,>H2)
Not sure what "B2:B" means, please edit your question to give some sample data and the outcome you wish to have plus the exact formula you have already (not "something similar to below"). – Kevin Anthony Oppegaard Rose – 2017-11-03T06:30:18.897
@KevinAnthonyOppegaardRose Edited, B2:B in google sheets basically just takes everything from B2 to the end of the column, ignoring B1, but for all purposes they are identical. - As for my current approach, I've tried countifs, sumifs, etc - nothing seems to work, its a bit beyond my knowledge really – NRGdallas – 2017-11-03T06:42:46.143
So, you want to count the number of occasions An+Bn+Cn>Dn, where n is the row number, for all rows. To do this you need a "FOR EACH" function, I dont think you can do this without VBA. – Kevin Anthony Oppegaard Rose – 2017-11-03T07:55:53.253