Hello everyone!
I'm not quite sure if my issue is unique or not, but here goes!
I'm trying to look down a column and find a result (either "Y" or "N") and then look at the cell next to it to see if the last character is a letter ("A", "B", "C", "N"). If those criteria are met, I would like it to return a total count of those items.
This is what I have so far:
Certified Stock Number Y P1864A Y P1823B N 14328N N P1745
So far, I have a SUMPRODUCT able to tell me if it meets "Y" in column A AND "A" on the right side of column B.Please Login or Register to view this content.
Is there a condensed way to include other letters in the right hand search without duplicating this formula over and over? To make it even more complicated, I have these types of tables across the spreadsheet multiple times for other models of product, so making it as condensed of an equation would be very helpful if it would ever need modification.
Thank you so much in advance!
Bookmarks