I'm having a problem with the below spreadsheet. Sheet1 contains values 3.1 through 3.11. Sheet2 counts # of times each Domain (eg, 1a,1b,1c) is present for each Standard (eg 1.1, 1.2, 1.3.)
The problem i am having is that when my countifs statement in sheet2 3b and 12b, looks for 3.1 and 3.10 respectively, both 3.1 and 3.10 are coming back as matches. How can I avoid this and have the count for 3.1 and 3.10 come up separately?
Thank you!
https://docs.google.com/spreadsheets/d/1qLwvlXW0xYs_cVfhAEUpQg8jZFOAZBQoTVPFDOTTRH0/edit?usp=sharing
The problem i am having is that when my countifs statement in sheet2 3b and 12b, looks for 3.1 and 3.10 respectively, both 3.1 and 3.10 are coming back as matches. How can I avoid this and have the count for 3.1 and 3.10 come up separately?
Thank you!
https://docs.google.com/spreadsheets/d/1qLwvlXW0xYs_cVfhAEUpQg8jZFOAZBQoTVPFDOTTRH0/edit?usp=sharing