Hello. I'm trying to add an IF statement to my existing equation. The goal is to count the number of times a certain item appears, but only if the status is "Checked out".
Excelhelp.png
To check how many Flippers (+-0.50) listed total, the equation is =SUMPRODUCT((LEN(E3:E7)-LEN(SUBSTITUTE(E3:E7, Items!A4,"")))/LEN(Items!A4)) *Items is a separate sheet.
How would I go about counting the number of times Flipper (+-0.50) is listed and tagged checked out?
I hope that is enough information. Thank you in advance! This has been taking a big toll on me.
Bookmarks