Peter Davison
Active Member
- Joined
- Jun 4, 2020
- Messages
- 433
- Office Version
- 365
- Platform
- Windows
I have a column (say A) with 100 rows of product numbers
I have a row (say 1) with 50 columns (C onwards) of store numbers
I have a sumifs in the body to calculate sales by product and by row
Is it possible to create a sumifs cell formula that spills to the last row and last column without me having to copy it down?
The reason is that my 100 rows of product numbers and 50 columns of store numbers can be variable.
Any help on this would be great.
I have a row (say 1) with 50 columns (C onwards) of store numbers
I have a sumifs in the body to calculate sales by product and by row
Is it possible to create a sumifs cell formula that spills to the last row and last column without me having to copy it down?
The reason is that my 100 rows of product numbers and 50 columns of store numbers can be variable.
Any help on this would be great.