SUMIFS for rows
 

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

Answer: SUMIFS for rows
 

Yes, you can definitely use the SUMIFS function to sum rows based on certain criteria. Here's how you can do it:

1. First, select the cell where you want the sum to appear.
2. Type the SUMIFS function, starting with an equals sign (=).
3. Within the parentheses, enter the range of cells that you want to sum. In this case, it would be L2:IV2.
4. Next, enter the range of cells that contains the criteria you want to use. In this case, it would be L1:IV1.
5. After that, enter the criteria that you want to use. For example, if you want to sum all the numbers in the range L2:IV2 where the criteria in the range L1:IV1 equals "x", you would enter "x" in the criteria section of the formula.
6. Repeat step 5 for any additional criteria you want to use. For example, if you want to sum all the numbers in the range L2:IV2 where the criteria in the range L1:IV1 equals "x" and the criteria in the range L1:IV1 equals "y", you would enter "x" and "y" in the criteria section of the formula, separated by commas.
7. Press Enter to calculate the sum.

Here's an example formula that sums the numbers in the range L2:IV2 where the criteria in the range L1:IV1 equals "x":

SUMIFS for rows
 

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

"SDMFG" wrote:

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