Hello I have following table:
Laptop available Desktop not available Desktop available Desktop not available Desktop available Laptop available Laptop available
I would like to count number of available and not available items based on item name:
TOTAL:
Desktops:
2 available
2 not available
Laptops:
3 available
0 not available
Can someone please tell me how can I achieve this?
Big thanks in advance
Try
=COUNTIFS(A:A,"Desktop",B:B,"available")
etc.
here you go try this
laptop.xlsx
uses countifs and cell references (i can explain in detail if required but probably not)
edit
got beat to itguess i should have just posted not put a book in lol
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
All works perfectly - thanks guys!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks