Formula Complex with IF and Count

**Sultix** · 04-29-2008, 06:46 PM

Hello experts,

pls see attached file, i am having problems with If and Count formula,

i dont know if this is very difficult. can anyone help me pls? especially with duplicate date entries in pieces table. same date but different pieces

The Table Results with blue colored columns should be filled with formulas, each of column, other than date and category.

It would be very nice, if anyone could help me out.

Just a side note, i dont want a VB Code. Just only with Formula.

Greets
Sultix

**daddylonglegs** · 04-29-2008, 07:09 PM

Put this formula in C33

=SUMPRODUCT(($A$15:$A$26=$A33)*($B$15:$B$26=$B33),INDEX($C$15:$E$26,0,MATCH(C$32,$C$14:$E$14,0)))

and this formula in D33

=C33*INDEX($D$4:$F$7,MATCH($B33,$C$4:$C$7,0), MATCH(C$32,$D$3:$F$3,0))

Now select both C33 and D33 and fill both formulas across and down to H52