Excel 2007 - COUNTIFS with nested OR and Cell References.

[Doge Robert]

Greetings all.

I have a list of data, where I need to count the number of replies based on certain criteria.

It looks something like this:

=countifs(Answers!$O:$O;J16;Answers!$C:$C;OR(C16;D16;E16);Answers!$M:$M;OR(F16;G16;H16))

(Please forgive any errors. I am translating from a danish version of Excel. (Hence the semicolons))

What I need the formula to do:
Look in Answers column O and count if the value equals cell J16.
Look in Answers column C and count if the value is equal to either the cell-value in c16, d16 or e16. - There may be multiple hits, each need to count
Look in Answers column M and count if the value is equal to either the cell-value in f16, g16 or h16. - There may be multiple hits, each need to count

If all these criteria are met, add 1 to the count, or more, if there are more than one hit with the or-fomulas.


How would you go about doing this?


Thanks in advance.

Robert.


- Sadly, I cannot upload an Excel-sheet, as I am writing from a business pc, where such is not permitted.