"Rosie" ha scritto nel messaggio
...
I have two tabs in a spreadsheet (DOG & CAT) and have the following
function
set up to compare 3 questions, ie. only if all three equal the value
required
is the corresponding values counted.

=COUNT(IF(DOG!J6:J1000=CAT!J7,IF(DIVA!S6:S1000=CAT !A12,IF(DOG!T6:T1000="0",DOG!B6:B1000,0))))

It's not working and returning strange amounts. It needs to look at the
dog
spreadsheet and compare the 3 different questions. How can I rearrange
this
to work?

Hi Rosie,

I think you could try with SUMPRODUCT function:

=SUMPRODUCT((DOG!J6:J1000=CAT!J7)*(DIVA!S6:S1000=C AT!A12)*(DOG!T6:T1000="0")*(DOG!B6:B1000))



--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy