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)