Forum Discussion
Checking for criteria in whole column
Hello, I am trying to get a formula that will lookup a criteria in one column and then return value in another column if that too matches a second criteria. How do I do this? Thanks
A concrete example with the expected result (hand calculated) would be useful.
Hi Peter, I can't send my actual working file as it contains sensitive data, so I've put more information into my example file to show what I mean. Thanks
A formula you might care to try is
= COUNTIFS(uniqueCode, uniqueCode, type, "Type1")where, hopefully, the defined names are obvious. With 365 the formula should spill to the entire column.