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?