many thanks on your replies why should i replace its with S and i went it Y

please advice

regards

"George A. Jululian" wrote:

Please help in this formula

{=SUM(('[Summary1.xls]A1 1-3'!$C$3:$C$19268=B$11)*('[Summary1.xls]A1
1-3'!$E$3:$E$19268=$A9)*('[Summary1.xls]A1
1-3'!$G$3:$G$19268=$H3)*'[Summary1.xls]A1 1-3'!$S$3:$Y$19268)}
the result should read 24 anf it give 0

please advise
regards