Combine SUMPRODUCT and SUMIF?

[Soulkage]

Hi Guys,

Iv been working on a spreadsheet and by request it just got lot more complicated for me and i cant quite seem to figure it out. I have two formulas which i need to combine, the first been

=SUMPRODUCT(--(tblExeTimes!$B$2:$B$6000>=B1),--(tblExeTimes!$B$2:$B$6000<C1),--ISNUMBER(SEARCH("Nathan",tblExeTimes!$G$2:$G$6000)))

and the second

=SUMIF(tblExeTimes!$G$2:$G$6000,"=Nathan",tblExeTimes!$F$2:$F$6000).

What i want exactly is to incorporate (tblExeTimes!$B$2:$B$6000>=B1),--(tblExeTimes!$B$2:$B$6000<C1) into the SUMIF as a search criteria (cells B1 & C1 contain dates). I seem to have come up against a brick wall with this one so any help would be most appreciated.

Many thanks in advance.

[DonkeyOte]

Based on your SUMIF you should find the below works:

=SUMPRODUCT(--(tblExeTimes!$B$2:$B$6000>=B1),--(tblExeTimes!$B$2:$B$6000<C1),--(tblExeTimes!$G$2:$G$6000="Nathan"),tblExeTimes!$F$2:$F$6000)