cancel
Showing results for 
Search instead for 
Did you mean: 

Analysis for excel: Excel formulas sumifs

former_member796211
Discoverer
0 Kudos

Hello!

I have workbook with Analysis for MS Excel in which use quite often formulas SUM, SUMIFS, VLOOKUP.

I inserted new columns/rows in grid, and set formulas.

But problem with ranges, how to set ranges for all rows/columns?

Now I set row/column name as range, but may be exist another way.

=SUM(A1:A20) - how to set as Range as formula?

Accepted Solutions (0)

Answers (0)