SUMIFS for rows

S

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
 
S

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...
 
Top