UDF that Sums based on 2 Criteria over 2 Criteria ranges

Assuming this definition:

Please Login or Register  to view this content.

where CellColor is criteria 1 and CoLetter is criteria 2

and

Please Login or Register  to view this content.

would return 50 in your example, then:

Please Login or Register  to view this content.

You only gave an example, not a specification. So here is the specification based on your example:

Sum the numeric values in a range, including those values that have a given value in the same row immediately to the left of the sum range, and with a fill color that matches the color of a given cell.

Please Login or Register  to view this content.

Please note an important difference between the two solutions.

walruseggman's solution assumes that you are checking column A for the letter that you want to match. That is a good solution if that is your situation. Mine is slightly more general in that it will look to the immediate left of the range containing the data. If your letters are always in column A then walruseggman's code is a bit simpler.

Agreed, @6StringJazzer. On that note, if you do want to change the column where the company letters are, just change the 1 in Cells(myCell.Row, 1).Value to whatever you want. It's still a hard-coded column, but does offer you a degree of flexability.

@6StringJazzer: would you care to discuss your use of myCell.Parent instead of just Cells? I'd just never seen that used before.