natesteiner21
New Member
- Joined
- Jul 10, 2012
- Messages
- 35
- Office Version
- 365
- Platform
- Windows
I have a worksheet that has ten columns. We'll call them A-J. I have set up a formula to count a/b, a/c, a/d, a/e and determine which ones meet the criteria that I've set up. Say it counts if there is an "x" in the rows. My issue is that I want to be able to check it for a/b, a/c, a/d, a/e, etc... and a/b/c, a/b/d, a/b/e, etc... and a/b/c/d, a/b/c/e, etc...
I've got the forumulas set up to do that but I'm doing something wrong because it is duplicating the data. i.e. if the row has an "x" in it for column a, b, c it counts it in a/b, a/c, b/c, and a/b/c. I only want it to count in the a/b/c area.
Same exact thing for f-j but using sumifs.
Any help out there? I can post the sheet if you would like.
I've got the forumulas set up to do that but I'm doing something wrong because it is duplicating the data. i.e. if the row has an "x" in it for column a, b, c it counts it in a/b, a/c, b/c, and a/b/c. I only want it to count in the a/b/c area.
Same exact thing for f-j but using sumifs.
Any help out there? I can post the sheet if you would like.