Analysis for excel: Excel formulas sumifs
618 views
0 comments
- SAP Managed Tags
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?
BlueskyAccepted Solutions (0)
Answers (0)
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.