Need Excel 365 formula to sum amounts in colored cells

riyaz · Nov 1st 2020

Hi,

I have some amounts in column A, B & C for eg., and some of the amounts are yellow colored, I need an excel 365 formula [w/o vba if possible] to sum total the amounts colored yellow in a different cell and if the color is removed the total should decrease by that amount.

Your help will be highly appreciated.

riyaz.

**royUK** · Nov 1st 2020

Try this UDF (User Defined Function), you can SUM, AVERAGE or COUNT by colour with it.

riyaz · Nov 2nd 2020

Dear Roy,

thank you for your response, but I couldn't grasp that formula, would be better if you could provide with a simple formula.

am a layman when it comes to using formulas

thanks,

riyaz.

**royUK** · Nov 2nd 2020

There is no formula available. A UDF is the only option and the workbook contains examples how to use the UDF as a worksheet formula.

riyaz · Nov 2nd 2020

Thank you Mr. Roy, I will study it once again, lets see.

Regards,

Riyaz.

deciog · Nov 2nd 2020

riyaz

Excel 4 functions are not Macro, to work you have to enable Macro and save with XLSM extension, I repeat is not Macro

Hope this helps

Decio

Share