Sundance_Kid
Board Regular
- Joined
- Sep 2, 2017
- Messages
- 155
- Office Version
- 365
- Platform
- Windows
Hi,
I am trying to figure out the correct formula to sum multiple columns based on single criteria.
I have a list of 30 names and the range contains all 30 names with multiple columns representing months of the year.
I want to sum 3 months (3 columns) for each name(criteria) but cant seem to get it right. I can do it for a single colum but I want to sum multiple columns.
I presume it should be a Sumifs formula or maybe even a sumproduct.
I dont necessarily want to create a helper column either as the formula will be working off a pivot table.
Thanks
I am trying to figure out the correct formula to sum multiple columns based on single criteria.
I have a list of 30 names and the range contains all 30 names with multiple columns representing months of the year.
I want to sum 3 months (3 columns) for each name(criteria) but cant seem to get it right. I can do it for a single colum but I want to sum multiple columns.
I presume it should be a Sumifs formula or maybe even a sumproduct.
I dont necessarily want to create a helper column either as the formula will be working off a pivot table.
Thanks