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.
Bookmarks