=sumproduct array with "and" or "or"

[TxMimi]

Currently I have a log that I am tracking metrics that I want to auto calculate in table format. (Not using a pivot table)

I am using this =SUMPRODUCT(--(RFSLog!$D$6:$D$1004="divi1"), --(RFSLog!$J$6:$J$1004>="01/01/2014"+0),--(RFSLog!$J$6:$J$1004<="01/31/2014"+0))

I am trying to get a total by the date range of the number of requests for div1 - which the above does, but I need to add an "AND" statement so that it searches column D for div1 and div2.

suggestions?

Thanks

 

[Andrew Poulsom]

Welcome to MrExcel.

Use + for OR:

=SUMPRODUCT(((RFSLog!$D$6:$D$1004="divi1")+(RFSLog!$D$6:$D$1004="divi2")), --(RFSLog!$J$6:$J$1004>="01/01/2014"+0),--(RFSLog!$J$6:$J$1004<="01/31/2014"+0))

 

[Asala42]

Try

=SUMPRODUCT(--((RFSLog!$D$6:$D$1004="divi1")+(RFSLog!$D$6:$D$1004="divi2")), --(RFSLog!$J$6:$J$1004>="01/01/2014"+0),--(RFSLog!$J$6:$J$1004<="01/31/2014"+0))

 

[TxMimi]

Worked like a champ...ya'll always come through. Thank you so much