• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need to calculate 4 tables in a sheet and show fix result in fix cells

Status
Not open for further replies.
udprocks

udprocks

Member
Hi all,

just posting here due to not get answer there

Cross post

https://www.excelforum.com/excel-fo...show-fix-result-in-fix-cells.html#post5304427


I have a sheet with 4 table which related to two columns i just want to calculate that tables and show result.

explanation:

1 - I need to count only 2 digit numbers from 4 tables ignore if there is only single digit in cell.

2 -count and show that numbers separately .

Hope it make sense. for better clarification i have attached sample.

Thanks in advance.
 

Attachments

  • Count 2 digit length in range using If and Sum.xlsx
    14.7 KB · Views: 2
In refer to the cross-post link , it is noted that your problem "Count only 2 digit numbers from 4 tables" is solved.

However it look like that you have 2nd question in asking for "Combine 4 tables 2 digit numbers into 1 table (as shown in the green colored area)".

So, should you wish to continue your query, new question new post.

Please post your new question in a new thread together with the attachment

This post closed

Regards
Bosco
 
Status
Not open for further replies.
Back
Top