Sum column F2:F1000 if there is CONDITIONAL FORMATTED color in Column E2:E1000

[acsishere]

Dear Friends,

I need a help.

In Column E2:E1000, I have applied a conditional formatting to apply a specific color based on a condition. The color applied nicely.

In Column F2:F1000, there are values (amount) which needs to be summed up if the same row of next column consist the color applied using Conditional Format.

For example:

Please Login or Register  to view this content.

I have applied conditional format in Col E, if it contains "APPLE", then apply Yellow color. In next column F, there amount mentioned.

Therefore, the Column F to be summed up if there is value "APPLE" in Col E. In above example, "APPLE" is applied, then the total is 805.

If "ORANGE" is applied, then the Total is 450.

Please note that the column E is conditionally formatted.

Please help me using VBA.

Thanks in advance.

[JohnTopley]

Why not have a data validation list of entries in column A and use a simply SUMIF(S) formula?

See here:

http://www.cpearson.com/Excel/CFColors.htm

[bakerman2]

JT's solution is the simplest and the best but if you do want VBA a small loop will do.

Please Login or Register  to view this content.