Hi,
Please help me to sum up the column based on the color in other column. In the attached file Column S would be in Three colors based on the parameters Met(In Green color),Partially Met(In Amber color), Not Met(In red Color).
Requirement is
We need to sum up the column M based on the colors in Column S and update the Cells F5,(Green- Met) Cell G5(Amber - partially Met), and H5(Red - not Met)
I have tried finding out the code of the color and sum up the M column, however it is not working as expected
Find attached the file and help
Note: problem should be solved with an excel formula but not with a VBA code
Please help me to sum up the column based on the color in other column. In the attached file Column S would be in Three colors based on the parameters Met(In Green color),Partially Met(In Amber color), Not Met(In red Color).
Requirement is
We need to sum up the column M based on the colors in Column S and update the Cells F5,(Green- Met) Cell G5(Amber - partially Met), and H5(Red - not Met)
I have tried finding out the code of the color and sum up the M column, however it is not working as expected
Find attached the file and help
Note: problem should be solved with an excel formula but not with a VBA code