SUMIFS with one criteria range that contains merged cells

**r4square** · 10-19-2012, 05:04 AM

I am having an issue with a simple speadsheet. I am attaching an example. In this example we have sales persons with their hours and sales $ in two separate columns underneath their name and district. The cells of name and district are both merged cells of two so that the two columns of hours and sales $ are underneath. Now I would like to sum up the districts numbers. By using the SUMIFS function I am getting the correct results for only the Sales $ however the Hours results is 0. I believe this to be because the Hours column is the second column underneath the merged Name and District cells. Would there be a way to do this without undoing the merged cells? Hopefully my attachment will explain my problem better. How can I make the SUMIFS formula or any formula make this work? Keep in mind this is a small example of the actual speadsheet, there are many more sales people so I would like to avoid having to sum up the district numbers manually.

**:) Sixthsense :)** · 10-19-2012, 05:27 AM

Refer the attachment file for solution.

---

Sixthsense

**r4square** · 10-19-2012, 06:01 AM

Thank you, simple solution and effective!

**[email protected]** · 11-16-2012, 02:37 AM

Hi Experts

Can any one help me out for the summation of merged cells. Herewith i am attaching the excel sheet. My worry is , if we change the start date and end date , how the values will be calculated by using SUMIFS function.

Thanks
Rams

**arlu1201** · 11-16-2012, 04:32 AM

Rams,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.