Posting as :
works at
You are currently posting as works at

## Repeat with me: NEVER merge cells on a calculation tab. Never! Repeat 3 times to be sure.Now, a simple, non-VBA way to do it is:=COUNTA(merged_cell_reference, adjacent_cell)Explanation: if cell A1 is merged with cell B1, and you do =COUNTA(A1,B1), as long as the merged cell is non-blank, the output will be 1 if the merged cell is non-blank; and if the cells are not merged, and both are non-blank, the output will be 2. P.s.:you can change to =COUNTBLANK() if you need the blank cellsYou need to manually enter the reference since excel merged the cells

Yes! I saw this message late and this is how I ended up doing it:

There was no text within some of the merged cells as they are currently representing spaces within a location. The merged cells represent double spaces, the blank cells, whether merged or unmerged represent sold spaces.

I was able to get a total number after I wrote in the word “sold” in the blank cells then used the CountA formula.

PS, after much research I learned what a nightmare merging cells is soooo this’ll probably be the last project I work on where I do so

## Why don’t you just change it from merging 2 cells to align text across selection?

There is no text within some of the merged cells as they are currently representing spaces within a location. The merged cells represent double spaces, the blank cells, whether merged or unmerged represent sold spaces.

I was able to get a total number after I wrote in the word “sold” in the blank cells then used the CountA formula.

## Thank you everyone for your input! There was no text within some of the merged cells as they are currently representing spaces within a location. The merged cells represent double spaces, the blank cells, whether merged or unmerged represent sold spaces. I was able to get a total number after I wrote in the word “sold” in the blank cells then used the CountA formula.

AWS﻿ Hello fishes, got a offer for L6 senior solutions architect at aws.

whats the max base i can ask, i feel getting low balled at 170K base. TC 250k.

The diversity officer at my old company:

## Additional Posts in Excel Genius

I have a field in excel that represents the GSID, that I want to concatenate to create a link. Example field GSID is 123-west and the link needs to be www.website/123_west.html for some reason using concatenate with left & right formulas to switch - to _ results in the field throwing an error. Anyone knows of a way to make this work?

### New to Fishbowl?

unlock all discussions on Fishbowl.
That was just a preview…
• Discover what it’s like to work at companies from real professionals
• Get candid advice from people in your field in a safe space
• Chat and network with other professionals in your field

Share

#### Embed this post

Copy and paste embed code on your site

Preview

See what’s happening in your industry
from the palm of your hand.

OR

Messaging rates may apply