sumbycolor

I currently have this, but don't know how to add it to sum by both colour and another column. Assuming the numbers are all coloured by their status, I need to sum based on that as well as the category in column A - how do I adjust the VBA code below to allow for that? Category Month A Month...

Hey all, I added to an Excel file the following module: Function SumByColor(CellColor As Range, rRange As Range) Dim cSum As Long Dim ColIndex As Integer ColIndex = CellColor.Interior.ColorIndex For Each cl In rRange If cl.Interior.ColorIndex = ColIndex Then cSum =...

Hi All I had this procedure working perfectly but it suddenly stopped and is not recognising CL as a variable. I have highlighted the CL in blue which is what excel does when it shows "Expected Function or Variable". Could anyone help please? I have remmed out col1 = CL.Interior.ColorIndex as I...

I'm using the vba code below to sum cells by their color and it's not really working to my need 1. It rounds the sum to nearest whole number. I need two decimals precision 2. It does some weird stuff, e.g. it sums 2 * 1,5 to 4 but it also sums 2 * 2,5 to 4... <tbody> A B C 1...

Good day! I have an Excel workbook that I am tracking labor costs, committed and actual. For the actual costs, I am using the "sumbycolor" code and it works great. I need to be able to also create a formula based on cell color and date range. So, I think I need to use a "sumifs" with a...

<tbody> Q1 16/17 Q2 16/17 Q3 16/17 Q4 16/17 Q1 16/17 Staff 500 500 400 350 200 Non Staff 300 450 Student 85 20 49 16 63 Total 585 520 449 366 263 </tbody> Black font : Agreed Red font: Approved Blue font: Potential I would like to have only sum of Agreed value and Approved Value...

I am using code below for SumByColor and it works great however it rounds my numbers what do I need to change? Function SumByColor(CellColor As Range, rRange As Range) Dim cSum As Long Dim ColIndex As Integer ColIndex = CellColor.Interior.ColorIndex For Each cl In rRange If...

I want to add cells that have the same font color, or if that's not possible, the same background color. I found a few functions which claim to do this. I copied/pasted into VBA, but keep getting #NAME? errors. This is the first time I have ever done Alt/F11 so I might be doing something...

Hello, I've been trying to sum a series of numbers using the SumByColor function, and it has no issues picking out the correct cells, but it rounds every sum cell to ".00" even when it shouldn't. For example, there is one sumbycolor cell that should reflect another cell of (26.03), but the sum...