Sundance_Kid
Board Regular
 Joined
 Sep 2, 2017
 Messages
 104
 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