Adding numbers that are only highlighted

[shaftdx]

Ok I hope I can do this and I hope I can get across what I mean.

I have an ever growing list of trips my company provides. I have 4 vendors that we quote the work out to. I sent out the trip and get the quoted price back for either of them. I choose what company is the cheapest and that price automatically Highlights.

I would like to find a way to have a "Summery" tab that will automatically not only add all the highlighted prices but also divide them up by the month so I can more easily do the invoicing.

I am sorry the page has client info so I can nod share a screen shot or anything like that.

does this make sense? I can go into more detail if needed

 

[mikerickson]

Does it matter where in the formula I put the next criteria for the Months?

Yes, which arguments you vary does matter.

 

[shaftdx]

Rather than sum based on what color column R is, sum based on what value column L has.
=SUMIF(L1:L1000, "Vendor 1", R1:R1000)

Hello again, is there a way I can Add things with two different criteria? The current formula I am using: =SUMIF(Trips!$O:$O,A$38,Trips!U:U) the A38 representing the event. is there a way I can add in a second criteria for the vendor?

 

[shaftdx]

Hello again, is there a way I can Add things with two different criteria? The current formula I am using: =SUMIF(Trips!$O:$O,A$38,Trips!U:U) the A38 representing the event. is there a way I can add in a second criteria for the vendor?

nevermind figured it out