# Formula to Sum Multiple Columns Based on Column Headings and Other Criteria

1. ## Formula to Sum Multiple Columns Based on Column Headings and Other Criteria

Hello,

I am hoping that someone can help me with the following issue. I need a formula that can sum up the total values in multiple columns based on the column headings plus criteria in other columns.

I've shown an example of the issue below (workbook attached).

Month Product Store A Store A Store B Store C
April Couch 300 242 14 3
May Sofa 131 413 131 3,242
June Bed 1,413 1,413 2,422 242
July Table 1,312 436 23,245 242

For example, in this instance I want to summarize the total values in the columns Store A for the criteria Month = April and Product = Couch. The value would be 542 using this criteria.

Does anyone know how this could be done?

2. ## Re: Formula to Sum Multiple Columns Based on Column Headings and Other Criteria

Solution deleted, does not work.

3. ## Re: Formula to Sum Multiple Columns Based on Column Headings and Other Criteria

Why do you have two columns for Store A?

4. ## Re: Formula to Sum Multiple Columns Based on Column Headings and Other Criteria

It's a flaw right now in how the data is laid out. However, for right now I have to keep these columns separate.

5. ## Re: Formula to Sum Multiple Columns Based on Column Headings and Other Criteria

Try this

=SUMPRODUCT((A4:A7=A11)*(B4:B7=B11)*(C3:F3=C10)*(C4:F7))

6. ## Re: Formula to Sum Multiple Columns Based on Column Headings and Other Criteria

It works!!!! Thank you so much!!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1