Lost with proper sumifs in VBA

Hi there,

This is my first post on this forum but as I've started a new position, I'm sure there will be many more.
I have attached my code.

I currently have it set to check values in column C against the left 4 in column A and then turn those pink if only that string exists, and then change it to the code in column C.
I have it set also to check if the values in C exist in completeness in A, and if so to turn those green.
Any values not existing will turn pink.

The two things I find myself struggling with now are as follows:

How do I set the code to ignore the first row in the range based on the actual label and
2) MOST importantly, how do I check the values in Col C after against those in column A, and then sum values corresponding to EACH cost code in adjacent column B, and paste the full sum next to the respective code in Col D?

Column C and D will eventually be located on a different sheet.

I apologize if this is unclear. I am absolutely new at this (I took it upon myself to start learning VBA last week) and I am having a hell of a time trying to come up with an effective solution as there is so much I don't yet understand.

Thank you for any and all advice and replies.

Please Login or Register  to view this content.

Hi there,

Thank you for the reply. I know how to access the sumif formula, but I can not seem to get it to work for what I am trying to do. I suppose I explain better.

Say that in column A I have 20 rows of cost codes, and in column B I have a corresponding 20 rows of amounts.

The proper codes are in column C; there will not be 20 of these. Duplicates of the codes exist in column A.

Say the first value in column C is 1234, the second is 2345, third, 3456, etc.

I want it to find all instances of 1234 in column A, sum their corresponding amounts, and paste them in column D next to the corresponding cost code, meaning the 1234 in column C.

I then want it to check column A for the next code, 2345, and sum all the corresponding amounts in column B next to the 2345s in column A. I want that sum pasted in column D next to the 2345 in column C.

Is this a better explanation?

I'm new to forum formatting, I apologize. Please see my reply.