=SUMPRODUCT(--(S8:S501="Yes"),--(A8:A501<""),(A8:A501))/COUNTIF(A8:A501,A8:A501&"")

It's work here, if you can send a sample of the type of data you have in
column A and S

HTH
Regards from Brazil
Marcelo

"IanEmery" escreveu:


Hi Steve

Thanks for your reply

I have changed the formula to reflect the correct field references aas
shown below but receive a #DIV/0! error:

=SUMPRODUCT(--(S8:S501="Yes"),--(A8:A501<""),A8:A501)/COUNTIF(A8:A501,A8:A501&"")

Can you see any problems ?

Thanks


--
IanEmery
------------------------------------------------------------------------
IanEmery's Profile: http://www.excelforum.com/member.php...o&userid=35714
View this thread: http://www.excelforum.com/showthread...hreadid=554978