I tried both of these formula and its working.

=SUMPRODUCT((A2:A21="CPL")*(C2:C21="M")*(D2:D21=20 71))

or

=SUMPRODUCT(--(A2:A20="CPL"),--(C2:C20="M"),--(D2:D20=2071))

based on your datatable , your col's ref is totally wrong
try adjusting the col's references.

HTH



Gene wrote:
here is what the formula looks like and I get an error #N/A

=SUMPRODUCT((A19:A142="CPL")*(B19:B142="M")*(C2:C 142=2071))

this is what my spreadsheet looks like

[quoted text clipped - 20 lines]

Can any one help me? By the way I need to do this in Excel 2003.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200812/1