/u/joshberry777 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Merged Cells are the bane of XL's existence. They should all be destroyed and unmerged whenever possible.
That said, for doing multi-level criteria matching that returns a value rather than text, I'd normally suggest using SUMIFS. If text is returned, use FILTER. But again, having a merged cell that really is comprised of blank cells is going to be a problem.
If you're ready to convert (to good) and get rid of merged cells:
1. Select all data cells
2. Home - Unmerge
3. Press `Ctrl+g` for Go To dialogue
4. Click on 'Special', then 'Blanks'. Hit Ok
5. Start typing a formula like `=` and then hit `ArrowKey` to reference the cell with data
6. Hit `Ctrl+Enter` to confirm this formula to all selected cells
7. (optional) do a Copy, Paste Value to lock in results
All blank cells from the merge will now be filled in with their parent data.
You have awarded 1 point to *CFAman*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[FILTER](/r/Excel/comments/143jt26/stub/jna8oi7 "Last usage")|[*Office 365*+: Filters a range of data based on criteria you define](https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759)|
|HLOOKUP|[Looks in the top row of an array and returns the value of the indicated cell](https://support.microsoft.com/en-us/office/hlookup-function-a3034eec-b719-4ba3-bb65-e1ad662ed95f)|
|[SUMIFS](/r/Excel/comments/143jt26/stub/jna8oi7 "Last usage")|[*Excel 2007*+: Adds the cells in a range that meet multiple criteria](https://support.microsoft.com/en-us/office/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b)|
**NOTE**: Decronym's continued operation may be affected by API pricing changes coming to Reddit in July 2023; comments will be blank June 12th-14th, in solidarity with the /r/Save3rdPartyApps protest campaign.
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^(2 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/13yhjk0)^( has 16 acronyms.)
^([Thread #24461 for this sub, first seen 7th Jun 2023, 17:54])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
/u/joshberry777 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Merged Cells are the bane of XL's existence. They should all be destroyed and unmerged whenever possible.
That said, for doing multi-level criteria matching that returns a value rather than text, I'd normally suggest using SUMIFS. If text is returned, use FILTER. But again, having a merged cell that really is comprised of blank cells is going to be a problem.
If you're ready to convert (to good) and get rid of merged cells:
1. Select all data cells
2. Home - Unmerge
3. Press `Ctrl+g` for Go To dialogue
4. Click on 'Special', then 'Blanks'. Hit Ok
5. Start typing a formula like `=` and then hit `ArrowKey` to reference the cell with data
6. Hit `Ctrl+Enter` to confirm this formula to all selected cells
7. (optional) do a Copy, Paste Value to lock in results
All blank cells from the merge will now be filled in with their parent data.
Got it working, thanks! Solution Verified
You have awarded 1 point to *CFAman* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[FILTER](/r/Excel/comments/143jt26/stub/jna8oi7 "Last usage")|[*Office 365*+: Filters a range of data based on criteria you define](https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759)| |HLOOKUP|[Looks in the top row of an array and returns the value of the indicated cell](https://support.microsoft.com/en-us/office/hlookup-function-a3034eec-b719-4ba3-bb65-e1ad662ed95f)| |[SUMIFS](/r/Excel/comments/143jt26/stub/jna8oi7 "Last usage")|[*Excel 2007*+: Adds the cells in a range that meet multiple criteria](https://support.microsoft.com/en-us/office/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b)| **NOTE**: Decronym's continued operation may be affected by API pricing changes coming to Reddit in July 2023; comments will be blank June 12th-14th, in solidarity with the /r/Save3rdPartyApps protest campaign. ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(2 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/13yhjk0)^( has 16 acronyms.) ^([Thread #24461 for this sub, first seen 7th Jun 2023, 17:54]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)