Hi all,
I'm hoping to get some help with a formula that will return a value if 3 different criteria are met across 3 different columns.
Below are the ranges and criteria for each:
F3:F230 – if a cell in this range is EITHER 'AG', 'HF', 'MH', or 'PO', then it should be counted in the final returned value
N3:N230 – if a cell in this range has a number that BEGINS WITH '2', then it should be counted in the final returned value
O3:O230 – if a cell in this range is 'F', then it should be counted in the final returned value
NOTE: the single quote marks don't appear in the cells.
In other words, I need a total count that includes the number of times all 3 criteria are met.
Many thanks,
Jared.
Bookmarks