Peo Sjoblom wrote:
You can use this formula as long as the ranges are equally sized

=SUM((B34:M34=1)*(TRANSPOSE(B3:B14)))

entered with ctrl + shift & enter

note that the condition =1 looks for a numeric 1 while your sumif looked
for a text value, if indeed they are text values use

=SUM((B34:M34="1")*(TRANSPOSE(B3:B14)))

Thanks that worked perfectly (plus taught me something new about Excel).

--
To contact me take a davidhowdon and add a @yahoo.co.uk to the end.