Forum Discussion
COUNTIFS for multiple ranges
Hi I'm struggling to complete this formula. I need to count to the total quantity of cells that have a value but only if they hit all 3 requirements. E.g. IF Column A says 'Douglas' an...
A solution using PIVOTBY:
=LET(
cc_col, IF(CC > 499, ">499", "<499"),
k, BYROW(data, COUNTA),
PIVOTBY(names, cc_col, k, SUM)
)