SUMIFS for rows

[SDMFG]

Can sumifs be used on ranges that are in rows, not columns? For example, sum
numbers in range L2:IV2 if criteria=x for criteria range L1:LIV?

Thanks

 

[Sheeloo]

Try
=SUMIF(L1:V1,"x",L2:V2)

there is no difference... all you need to do is specify a row range instead
of column range...