After working on this for 2 hours I decided to try community help/assistance for the first time and I'd greatly appreciate help on this.
The Conundrum
I'd trying several variations of COUNTIFS and SUMIFS. I'm attempting to determine the total number of times the text value of Y or N was entered in a single column.
I'm able to get the total # of occurrences for the text value of Y, which was 35, by using this formula.
=COUNTIF(Questions!H6:H94,"Y")
I'm able to get the total # of occurrences for the text value of N, which was 42, by using this formula.
=COUNTIF(Questions!H6:H94,"N")
Now I am trying to figure out how to combine those into a single formula that would get me a total # of occurrences for the text value of Y & N in a single column, which would be 76. Here's the formulas I've attempted to use.
=SUMIFS(Questions!H6:H94,"Y",Questions!H6:H94,"N")
=COUNTIFS(Questions!H6:H94,"Y",Questions!H6:H94,"N")
When I attempt to use in excel it does nothing. Again, I'd appreciate help on this.
The Conundrum
I'd trying several variations of COUNTIFS and SUMIFS. I'm attempting to determine the total number of times the text value of Y or N was entered in a single column.
I'm able to get the total # of occurrences for the text value of Y, which was 35, by using this formula.
=COUNTIF(Questions!H6:H94,"Y")
I'm able to get the total # of occurrences for the text value of N, which was 42, by using this formula.
=COUNTIF(Questions!H6:H94,"N")
Now I am trying to figure out how to combine those into a single formula that would get me a total # of occurrences for the text value of Y & N in a single column, which would be 76. Here's the formulas I've attempted to use.
=SUMIFS(Questions!H6:H94,"Y",Questions!H6:H94,"N")
=COUNTIFS(Questions!H6:H94,"Y",Questions!H6:H94,"N")
When I attempt to use in excel it does nothing. Again, I'd appreciate help on this.
