try

=SUMPRODUCT((x4:Y100=5)*(e4:e100=2))

"alh06" wrote:

Unfortunately that does not work - when I do that it tries to find people who
answered as '2' in all 3 columns ... and then brings back a 0%.

When I said I'm looking at 3 columns -- I meant someone can only choose '2'
once w/in those 3 columns. So for one person, if they chose '2' it will only
be show '2' within all 3 columns: one person may have '2' in X while another
may have '2' in W -- which is why I need to search that entire range as a
whole.

Writing the formula out this way is looking for a person who answered '2' in
all three columns, and it is impossible. I'm looking for people who answered
'2' w/in the range of all 3 columns. (is that making sense?)

Any other ideas?

"Eduardo" wrote:

Hi,

=SUMPRODUCT(--(x4:x100=5),--(y4:y100=5),--(z4:z100=5),--(e4:e100=2))