•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Countif only no-whole numbers
I have a database with numbered categorized products like so.
1.00 Food
1.01 Rice
1.02 Meat
1.03 Potato
2.00 Clothes
2.01 Pants
2.02 Shirts
I need to check how many products there are, meaning that the category headers (the ones with whole numbers) should not be counted. In the example the correct output would be "5".
I tried to use a countif + if function but i ended up having to use another column to make it work and that will create bugs in the future, any ideas on how to tackle this?
Edit: spelling
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#financial modeling with spreadsheets
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#countif
#database
#categorized products
#whole numbers
#category headers
#count
#function
#products
#if statement
#output
#column
#bugs
#ideas
#example
#spelling