Help & Support
Send Feedback
Sum All Cells Based On Colour
A single function designed to Sum all cells that do not have a specified background colour. =SumAllCellsThatAreNotThisColour("A1:A2","#00ff00")
theblackpencil.co.uk
20 users
Works with
Install
Overview
A suite of functions designed to Sum all cells based on a specified background colour.

SumAllCellsThatAreNotThisColour(Range, HexColour)
SumAllCellsThatAreThisColour(Range, HexColour)

e.g. =SumAllCellsThatAreThisColour(A1:A5, "#00ff00")
Reviews
No comments
Additional information
Search
Clear search
Close search
Google apps
Main menu