1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Can I Produce a Partial Count (Using =COUNTIFS) Based on Percentages?

https://preview.redd.it/vadb8ag1njhg1.png?width=299&format=png&auto=webp&s=c9d29e29527823faa6e315e6d545bd3f28d3e82c

I need a formula that can count people based on percentages. I have a dataset that looks like this and I want to count how many people are attributed to each building without counting them twice.

submitted by /u/ponopo
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#cloud-based spreadsheet applications
#AI formula generation techniques
#Excel compatibility
#large dataset processing
#Excel alternatives for data analysis
#COUNTIFS
#percentages
#formula
#count
#dataset
#building
#attributed
#people
#partial count
#twice
#attribute
#Excel
#submission
#reddit