Thank you for your detail reply, your method is ok, it can works !
Anyway, I have another issue as photos below
As my blocks setting, when Labels are green color, get a result to add the texts together,
it’s ok as photo#1.
But when I want to set when all labels are white colors, get a result = 0,
it fails, it gets a result still = 60, as photo#2.
I want to get a result = 0, as photo#3,
what’s wrong with my blocks setting ?
How can I correct them ?
Thanks for your helps and any suggestion!
is this the logic you’re trying to do?
before you enter the FOR EACH loop, set Number to 0
inside your loop do this:
IF color is not white
add value to Number
at END of FOR EACH LOOP
check for NUmber
if Number is zero, all cells are white
if Number is not zero - its the sum of all that’s not white.
that’s what it seems like to me
Your method works, it’s simple and perfect, this issue wasted me much time.
I highly appreciate you and Thank You very much for your help!
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.