Question: How to Skip Merged Cells in SUM | سؤال: كيف نتخطى الخلايا المدمجة في

Hello guys,
Firstly, my English is not that powerful that's why I posted my post in this section

however, how can I get rid of merged cells in my sums? No VBA Please

I attached the file to show you what I mean
Demo - Copy.xlsx

I do not understand. Please try to explain again (even in arabic, as we can use Google translate) BUT ALSO add expected answers to your file (make it with FEWER rows)

Administrative Note:

Welcome to the forum.

Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

Thank you for helping us to help you.

The simplest way would be to not used merged cells in the 1st place - we always recommend avoiding them if at all possible, they cause all sorts of problems with formulas and code.

If you MUST use merged cells, you can manually adjust your formula...
=SUM(A2:B65)
adjusted to
=SUM(A2:A65)

Ford, that doesn't work. in a merged cell, the values are "stored" in the left hand cell. So all values are in column A, whether in a merged cell or not.

In your sample, the values in the merged cells are 1 trhough to 31. If that is REALLY the case, you can use:

=SUM(A$2:A$66)-SUM(ROW($1:$31))

If the intent is to add the 1 to 31 values (496 total) plus the stand-alone values in A59, A60 etc(1781 total), then the =SUM(A2:A65) does work.

If the intent is to just add the stand-alone, then you are correct, =SUM(A2:A65) wont work.

I took it the OP wanted to sum all visible values - I guess time will tell

You're welcome. Thanks for letting us know that you got an answer.

---

Please take a moment and consider clicking the "Add Reputation" button at the foot of any of the posts of anyone who helped you reach a solution here today.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.