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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumifs in Excel 2007 for only numerical values 15
SUMIFS error 1
Lessons from optimizing a slow spreadsheet 2
sumif on a single criteria rows but several sum rows 3
sumifs problem 1
How can I use OR function inside SUMIFS 3
SUMIFS 3
Using Sumifs combined with an "Or" 4

Top