select  data to each section

ADRIANA P
ADRIANA P used Ask the Experts™
on
select  0 and 1

as show  

 gg22222.png
then

gg11111.PNG
then

gg23333.png
the total
gg11111.PNG
2N_01_to_count.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
You say 'total" but it looks like you want a concatenation (concatenación). Is that correct?
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
And the "total" needs to be in ORD order correct?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
And the "total" needs to be in ORD order correct?

Yes ! Sir
Older than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
Try this. My results for rows 18 and 31 are different from yours and so if yours are correct then please tell me why.
29118917.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Perfect !!

As needed

Great JOb !

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial