=COUNTIFS($A$2:$A$10,"red",$B$2:$B$10,"legit",$C$2:$C$10,"available")
From an inventory of red, blue and plaid pills, how many legitimate red pills are available?
View Excel table and formula: http://1drv.ms/1OkNlgk
This formula also works in Google Sheets and LibreOffice Calc.
View Excel table and formula: http://1drv.ms/1OkNlgk
This formula also works in Google Sheets and LibreOffice Calc.
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.