Hi

Not shorter, but this one may give you some gain in speed, when you have a
lot of such formulas

=SUMPRODUCT(--($D$2:$D502=D507),--($F$2:$F502=""),($E$2:$E502))


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"DaveMoore" wrote in message
oups.com...

Got it!

=SUMPRODUCT(($D$2:$D502=D507)*($F$2:$F502="")*($E$ 2:$E502))

works for me.

Are there any shorter versions?