I am attempting to sum the number of occurrences for the following:
(1) Column C contains the number 3 (all cells in this column contain both text and numbers)
(2) Column B equals "Open"
(3) Column K equals "Design"
This is my working formula, but isn't working. The error is in the first array, I've forgotten how to find/sum cells which contain certain text/numbers.
=SUMPRODUCT(
--ISNUMBER(MATCH('AIM data'!$C$2:$C$10000,{"*3*"},0)),
--('AIM data'!$B$2:$B$10000="Open"),
--('AIM data'!$K$2:$K$10000="Design"))
TIA -James
(1) Column C contains the number 3 (all cells in this column contain both text and numbers)
(2) Column B equals "Open"
(3) Column K equals "Design"
This is my working formula, but isn't working. The error is in the first array, I've forgotten how to find/sum cells which contain certain text/numbers.
=SUMPRODUCT(
--ISNUMBER(MATCH('AIM data'!$C$2:$C$10000,{"*3*"},0)),
--('AIM data'!$B$2:$B$10000="Open"),
--('AIM data'!$K$2:$K$10000="Design"))
TIA -James