Get Total of Specific Background Colored Cells Pt. 2

This question is building off the elegant solution provided by Alan found in my previous post.

I was trying to modify his code as my excel spreadsheet expanded to:

2021-04-19_16-41-33.png

How to automatically get the sub-totals from each blocks (shown in P11-P13, AB11-AB13, P19-P21 and AB19-AB21) then get the overall total to show up in Column E.

The original VBA code written by Alan is:

Please Login or Register  to view this content.

Please note that I have also cross-posted this question on Mr. Excel but due to my limited posts on this forum I cannot attach the actual link. The post on Mr. Excel is #post-5678201

https://www.mrexcel.com/board/thread.../#post-5678201

Welcome (back) to the forum.

Thanks for your question. However, we have just found out that you have posted the same question elsewhere.... and haven't told us. Feel free to cross-post on other sites...

But. Every forum has its rules. Please see Forum Rule #3 about cross-posting. So.

Do not keep it a secret. We all are willing to give you our time, freely. However, some of us get very annoyed if we waste our time developing a solution for you, when you already have a nice solution elsewhere. All we ask is that you show us some respect and tell us:

1) if you have cross-posted, and

2) the URL of the cross posts.

That way, those of us who don't want to waste their time can quickly check to see if you're already happy with another solution.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

I put the link to the post on Mr. Excel in quotes.

Thanks for making me aware of this requirement!

Sincerest apologies!

Thanks. The link is now live. Open for anyone to help.

Will the area of the ranges always be the size you are showing in your example. Are the range areas fixed or dynamic?

Hello,

The range area and ranges are fixed.

Hello Alan,

I did not get the code if you placed it here, but would making the ranges dynamic easier? Thanks!

I've been trying all night and could not get it to work properly.

I thought I had a solution for you with fixed ranges, but it turned out to be more complicated and complex than I was able to figure out. I don't have a solution for you when there are more than one table that needs to be summarized and totaled. I have posted alerting others to have a look/see. Patience may need to be the word today.

Hard coded blocks and ranges:

Please Login or Register  to view this content.

Hello Ben,

Thank you for your elegant solution! I sincerely appreciate it!

I can't believe it was done is just those few lines of code! Thank you!

One extra requirement: How to also get the sub totals to show up from each block?

I was thinking of using this:

Please Login or Register  to view this content.

Thanks again! Sincerely appreciated!

Please don't quote whole posts -- it's just clutter.*If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding. I have removed the extraneous quote.

Please Login or Register  to view this content.