Not sure how to best do this.
My Data Table looks like this. Starts in A1.

ColA ColB ColC ColD ColE ColF
FirmID Date Message Status Reject Count
BOX005 24-Jan Entry Directed 2
BOX005 24-Jan Entry 7
BOX005 24-Jan Entry 35
BOX005 24-Jan Outcome Eliminated 2
BOX005 24-Jan Outcome 17
BOX005 24-Jan Outcome 8
BOX005 24-Jan Outcome 16
BOX005 24-Jan Trade 7
BOX005 24-Jan Trade 1
BOX005 24-Jan Trade OK 2
BOX005 24-Jan Trade 55
BOX017 24-Jan Error 11
BOX017 24-Jan Error 4
BOX017 24-Jan Entry 282

Trying to create this table. Table starts in A1. Would like a formula in B3
to sum ColF (Count) from Data Table if value in B1,C1 etc matches ColB (Date)
in Data Table, value in A3,A4, etc matches ColA in Data Table, value in B2
matches ColC in Data Table, and finally value in C2 matches ColD. Would like
to copy this formula across the spreadsheet but if no match B1,C1 etc to ColB
of Data Table return "NoData".



24-Jan 24-Jan 23-Jan 23-Jan
FirmID Order Entry Directed Order Entry Directed
BOX005 44 2 No Data No Data
BOX017 282 0 No Data No Data

Is this do-able ? Thank you in advance.

Format the result cells as 0;;"No Data", and add this formula

=SUMPRODUCT(--(Sheet2!$A$1:$A$30=$A3),--(Sheet2!$B$1:$B$30=B$1),--(Sheet2!$C$1:$C$30=B$2),Sheet2!$F$1:$F$30)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"carl" wrote in message
...
Not sure how to best do this.
My Data Table looks like this. Starts in A1.

ColA ColB ColC ColD ColE ColF
FirmID Date Message Status Reject Count
BOX005 24-Jan Entry Directed 2
BOX005 24-Jan Entry 7
BOX005 24-Jan Entry 35
BOX005 24-Jan Outcome Eliminated 2
BOX005 24-Jan Outcome 17
BOX005 24-Jan Outcome 8
BOX005 24-Jan Outcome 16
BOX005 24-Jan Trade 7
BOX005 24-Jan Trade 1
BOX005 24-Jan Trade OK 2
BOX005 24-Jan Trade 55
BOX017 24-Jan Error 11
BOX017 24-Jan Error 4
BOX017 24-Jan Entry 282

Trying to create this table. Table starts in A1. Would like a formula in
B3
to sum ColF (Count) from Data Table if value in B1,C1 etc matches ColB
(Date)
in Data Table, value in A3,A4, etc matches ColA in Data Table, value in B2
matches ColC in Data Table, and finally value in C2 matches ColD. Would
like
to copy this formula across the spreadsheet but if no match B1,C1 etc to
ColB
of Data Table return "NoData".



24-Jan 24-Jan 23-Jan 23-Jan
FirmID Order Entry Directed Order Entry Directed
BOX005 44 2 No Data No Data
BOX017 282 0 No Data No Data

Is this do-able ? Thank you in advance.