Sum for each different name

Is there a reason you're using VBA for this rather than just a SUMIF formula?

This in F4 then copied down will yield the expected results (albeit after you've corrected the mispelling of Volkswagen in column A):

Formula:

Please Login or Register  to view this content.

Could the same car names appear further down the list or would they always be together?
If they could appear elsewhere in the list do you want to sum them altogether (if so use the formula approach), if you only want to sum them in distinct chuncks then we can help with code for that.

BSB

Hi
Thanks a lot for your quick reply, that's much appreciated.
I am trying to use VBA rather than the SUMIF formula as in the actual Excel file I got thousands of rows, and that will take time, to manually change the input within each formula. So I'm trying to automatise that by using a FOR loop instead.

To answer the 2nd question, the cars name will always appear packed together, without discontinuity, so they won't appear further down out of nowhere.

That's cool!
Thanks a lot! Well, yeah the formula works, however, I have to manually change E4 with each string when the Car Name changes, otherwise I'll get the same sum thousand of times until the next Car Name

Please Login or Register  to view this content.

If you were using a more up to date version of Excel than your profile shows then you could use the =UNIQUE() formula to generate the list of car names then you wouldn't have to change anything.

I think the Pivot Table is probable the easiest method for this (even though I detest them!)

BSB

Thanks a lot!
Solved, REP+

@Sintek, in this case you could do this without using .exists

Please Login or Register  to view this content.