SumByColor

%3CLINGO-SUB%20id%3D%22lingo-sub-1374086%22%20slang%3D%22en-US%22%3ESumByColor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1374086%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20add%20up%26nbsp%3Bcertain%20cells%20that%20I%20highlight%20in%20a%20spreadsheet.%3C%2FP%3E%3CP%3EI%20thought%20several%20years%20ago%20I%20could%20do%20that%20with%20a%20Sum%20By%20Color%20formula%2C%20but%20it%20no%20longer%20works.%3C%2FP%3E%3CP%3EEspecially%20in%20updated%20excel.%3C%2FP%3E%3CP%3ECan%20you%20assist%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1374086%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1374173%22%20slang%3D%22en-US%22%3ERE%3A%20SumByColor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1374173%22%20slang%3D%22en-US%22%3E%3D%40SumByColor(O8%2CO8%3AO545)%20This%20used%20to%20work%20but%20no%20longer%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1374465%22%20slang%3D%22en-US%22%3ERE%3A%20SumByColor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1374465%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F660859%22%20target%3D%22_blank%22%3E%40JoniWeise%3C%2FA%3E%26nbsp%3BI%20suspect%20that%20you%20had%20a%20User%20Defined%20Function%20on%20your%20system%20before%20updating%20Excel.%20Similar%20to%20what%20you%20find%20in%20the%20attached%20link.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.exceltrick.com%2Fhow_to%2Fsum-cells-based-on-background-color%2F%3F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.exceltrick.com%2Fhow_to%2Fsum-cells-based-on-background-color%2F%3F%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20my%20knowledge%2C%20%26nbsp%3B%3CSTRONG%3ESumByColor%3C%2FSTRONG%3E%20has%20%3CU%3Enever%3C%2FU%3E%20been%20a%20standard%20Excel%20function.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I am trying to add up certain cells that I highlight in a spreadsheet.

I thought several years ago I could do that with a Sum By Color formula, but it no longer works.

Especially in updated excel.

Can you assist?

2 Replies
Highlighted
=@SumByColor(O8,O8:O545) This used to work but no longer
Highlighted

@JoniWeise I suspect that you had a User Defined Function on your system before updating Excel. Similar to what you find in the attached link.

https://www.exceltrick.com/how_to/sum-cells-based-on-background-color/? 

 

To my knowledge,  SumByColor has never been a standard Excel function.