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