I will try to explain this the best i can forgive me if it doesnt come across as anticipated.

i am trying to get sumproduct to work out a formula based on several criteria.

i can get the individual sections to work but when i combine them i get incorrect results.

i am using data from 15 columns. the first two columns are a simple 'and' to ensure they both contain the data i require, the final column holds a date which i want to test the month of only.

=sumproduct((a1:a10 ="16")*(b1:b10="attended"))

this will return the correct number of lines matching the criteria

the other columns are paired up - one holds a date the other hold a 'yes','no' or 'pending' value, and there are 4 pairs of these.

i have had to use 'Isnumber' as well to check for blanks, as this was throwing the formula out.

=sumproduct((isnumber(C1:C10)*(month(C1:C10)=Month(O1:O10))*(D1:D10="attended"))+(isnumber(E1:E10)*(month(E1:E10)=Month(O1:O10))*(F1:F10="attended")) + etc,etc for the remaining columns

this will give me a count.

How can i incorporate the first sumrpoduct to this to make sure it only adds the second sumproduct when the criteria match for both ?

=sumproduct(((a1:a10 ="16")*(b1:b10="attended"))*((isnumber(C1:C10)*(month(C1:C10)=Month(O1:O10))*(D1:D10="attended"))+(isnumber(E1:E10)*(month(E1:E10)=Month(O1:O10))*(F1:F10="attended")) + etc etc

if '16 and attended' i should get a 1 (true) for the first row
i should get a number of how many pairs matched from the second sumproduct which i can multiply by the first reult ( 1 x 4, 1 x 6 etc etc)

i am doing this correctly trying to do it all in just one sumproduct or should i be using two ?
i have looked a several articles and done multiple dry runs against my data but it is only when i try to merge the two i get the problem.

any help or pointers appreciated.