Hello. I am trying to turn this logic into a formula:
Count the total number of rows on worksheet 'Main' in which Column A equals 101 AND Column B equals 2
I have been trying to figure this out for a couple hours and once the headache came on, I decided it was time to get help. I truly appreciate any suggestions and assistance. Thank you in advance!
-K
I have figured it out. In the event anyone else faces this question, I will post the formula below.
=SUM((ISNUMBER(SEARCH("101",Main!A2:A20)))*(ISNUMBER(SEARCH("2",Main!B2:B20))))
When you are ready to enter the formula, hold down Ctrl and Shift, THEN press enter.
Last edited by karma; 01-07-2005 at 10:25 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks