allthingstech
New Member
- Joined
- Nov 26, 2016
- Messages
- 4
how can I display results from two columns using COUNTIF FUNCTION OR
=SUMPRODUCT(--ISNUMBER(SEARCH(" MAIN "," "&A1:A1000&" ")))
=SUMPRODUCT(--ISNUMBER(SEARCH(" MAIN "," "&A1:A1000&" ")))