Counting data acros columns based on criteria

Hi

If anyone has a solution to my problem, i am looking for a formula to count cells in a row depending on criteria in another corresponding cell in a row below.

Thank you!!

The above formula suits your file type but you'll need this alternative to suit your profile's version (2003)

=SUMPRODUCT(($B16:$F16="X")*($B$23:$F$23=1))

thanks Cutter, it was for 2003. It works like a charm.

You're welcome. Don't forget to mark your thread as SOLVED (click Forum Rules @ top of page - see rule #9 for instructions).