It looks like I've misunderstood completely the requirement.


To help me better understand, I'd like you to explain to me how you arrived at the result in just one cell. Please refer to the file I attached in my last message so we're both talking about the same cells.
I'm interested in how you arrive at the R in cell AB17, which is for row 17 and January 2022.
You say R means there are 3 or more negative values.
I'd like you to tell me:
1. Which 3 or more cells contain the negative values to get that R result in just that one cell AB17
2. Which cells should just that cell AB17 examine to see if they are negative or not.


If you want to do the same with a few other result cells to make thing clearer, that's fine. Cell AD5 would be a good one.

hi p45cal

from col C - P the date in weekly format, that's why need to check 4-5 col to determine the whole month.
where col Q - V in monthly format which only 1 cell to determine either G or R only.

Please, again:

Originally Posted by p45cal
I'd like you to tell me:
1. Which 3 or more cells contain the negative values to get that R result in just that one cell AB17
AB17 is month JAN, and cell Q1 is the only JAN to indicate with. its unable to compare 3 or not to indicate R. with one cell only, shld be either R or G
2. Which cells should just that cell AB17 examine to see if they are negative or not.
as mentioned above AB17 is JAN, from Col C - Col V, only Col Q is JAN, so shld be either R or G