Value! Error with Multi Conditions in Excel

[rdaytonmoore]

I'm working with a large amount of data, from a call log, and need to sum the duration (time) of the call (D:D) when C:C = "Queue 1" and H:H = "Rep 1". Both column C and Column H are text. There are two tabs (data, report)

I have tired several different equations

=sum((data!C:C=Report!a4)*(data!h:h=report!c6)*data!D:D)

Instead of enter I push Shift Ctrl enter, this gives me a Value! Error. Should I use another equation? Or is there a way to get Excel to not return the Value! Error.

thank you!

 

[VoG]

Try

=sumproduct(--(data!C1:C100=Report!a4),--(data!h1:h100=report!c6),data!D1:D100)

This doesn't require CTRL + Shift + Enter but you can't use whole column references like D:D

 

[rdaytonmoore]

Unfortunately this returns zeros.

 

[VoG]

Try using Excel Jeanie http://www.excel-jeanie-html.de/html/hlp_schnell_en.php to post a small sample from the Data sheet. Also what is in Report A4 and C6?