Hi!
I am trying to do a percentage of how many yes and how many nos I have in one column. I tried a couple of formulas and I am coming with some weird answers. For instance.
=[Percentage of IPE Yes and No]1 - [Percentage of IPE Yes and No]2 / [Percentage of IPE Yes and No]1 and my answers comes out to be 4,773%
I have also tried the =CountIf (##:##. "Yes") / Count(##:##)
I have already have a formula for the total number for "Yes" and a formula for the total number of "No" which is an example of the following
=COUNTIF(IPCE1:IPCE520, "No")
Which I used a different column for the totals of Yes and No, Now I am trying to use the same Column but different row to calculate the percentage of both?
Hopefully, this makes sense.
Can someone please help?
I really think I am over thinking it.