On Sat, 15 Oct 2005 10:41:40 -0700, "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)))

I like it. That's a new one for me.

Thanks Peo

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________