top of page
  • David Sparks

Excel Data Sum by Color

This may seem a bit off topic to many, but if you spend time in Microsoft Excel dealing with data (work at an engineering firm?) this is something that can come in handy. I came across this post on the website "TrumpExcel" by user Sumit Bansal and thought I'd share it:

Essentially, you can get the sum of different cells based on their color. Very helpful if you use cell colors to differentiate data. Surprisingly, this is something Excel does not do natively. I especially like his Visual Basic code for creating a back end function making it quick and easy to use over and over.

6 views0 comments

Recent Posts

See All

Ray Tracing and Two-Sided Foliage

A few years ago, as I was preparing my foliage libraries for sale on the Unreal Engine Marketplace, I had issues with Ray Tracing (a relatively new feature in UE 4.2X) and the Two Sided Foliage shader

William Faucher on Unreal Engine

I've been running into this guy's YouTube videos a lot over the last year or two. I needed to make a shout out. He's got excellent explanations on solutions to common issues in the engine as well cont


bottom of page