Search results for query: *

To take the problem a step further - how could I match two columns and return the sum of the values matched in a third, for example Worksheet1 ColA ColB ColC 91 2100 45.00 120 2105 20.00 91 2100 10.00 125 2100...

I don't think a pivot table would be a good idea, as it wouldn't return the cell in the list containing Target No - so you'd then have to pull the info from the Pivot Table, I did try that But thank you - good idea

Hey - reading the post about 3 items down, helped me fix this, the solution is =sumif(ColA,TargetNo,ColC) Thanks so much, have been scratching my head for days! [3eyes]

Hi I have a worksheet containing a number of columns One column contains a series of 4 digit numbers, and a 2 columns to the right contains a value I need to add only values which match the same 4 digit numbers to a separate location For example: Col A Col C 2101 45.40...