Help w/ Formula!
Yes, that IS what I'm looking for!! I had to change the COUNT part to COUNTIF
because I'm only looking to find the percentage of the number of "2"s that
answered, but I could change that on my own. :)
Now I have another question ... when I'm looking at people who identified as
a '2' -- I'm actually looking at 3 columns for those numbers (range 4:100).
How do I put that into the equation ... I tried to just write
=SUMPRODUCT(--(V4:W100=2),--(E4:E100=5))
but it said the Value was wrong ... so I tried to put V4:V100, W4:W100,
X4:X100 and that didn't work either. I'm guessing I have to put them each in
on their own, but I don't know entirely where they go in regard to
parenthesis and funny dashes. :)
Thank you so much!!
Amber
"MarkN" wrote:
Hello,
=SUMPRODUCT(--(A2:A9=2),--(B2:B9=5))/COUNT(A2:A9)
will return the percentage of the total number in col a with values of 2 who
also have the value 5 on the corresponding row of col b.
Is that what you're after?
--
Cheers,
MarkN
"alh06" wrote:
This is what I am trying to find:
Of the people in column 'A' who identified as a "2", what percentage also
identified as a "5" in column 'B'? --
I have no clue what formula to use - I tried using COUNTIF combined with IF
and thought it was right, but now certain numbers aren't working out
correctly. Then i thought maybe I needed to use AND as I'm trying to find two
things??
If anyone can give me a template using my information above, that would be
fantastic! Thank you!
|