Thread: correct syntax for adding a set of coordinates to a SUMPRODUCT formula

Hello again,

The sumproduct formula I am using (thx to NBVC) is adding numbers from a column on one sheet using text and date criteria:

=SUMPRODUCT(--(ISNUMBER(SEARCH("auto",'register - BoA'!$D$6:$D$90))),--(TEXT('register - BoA'!$C$6:$C$90,"mmmm")="May"),'register - BoA'!$F$6:$F$90)

I would like to add a sheet to the array but am having difficulty with the syntax. I need help including the sum of coordinates from the new sheet using the same text and date criteria.

sheet name: 'cash receipts'
search for: "auto" in c6:c42 and the month of "May" in b6:b42
sum: figures in d6:d42

Is an argument separator necessary to add 2 sets of arrays together?

Thanks very much as always.

lallo.jr,

Try:

=SUMPRODUCT(--(ISNUMBER(SEARCH("auto",'register - BoA'!$D$6:$D$90))),--(TEXT('register - BoA'!$C$6:$C$90,"mmmm")="May"),'register - BoA'!$F$6:$F$90)+SUMPRODUCT(--(ISNUMBER(SEARCH("auto",'cash receipts'!$C$6:$C$42))),--(TEXT('cash receipts'!$B$6:$B$42,"mmmm")="May"),'cash receipts'!$D$6:$D$42)