Sum of (If match in one column then take value in another column same row) - Stumped!

[Zeke XA3]

Hi there,

Stumped myself taking on a little piece of work for a friend after showing off some basic VBA user form skills a few months ago.

Situation

Sheet 1
Column C contains a drop down box for course selection
Coloumn K contains a user inputed value for amount paid so far

Sheet 2
Column B contains a list of courses

I would like column C in sheet 2 to have something like the following:

If the entry in column c sheet 1 matches an entry in column b sheet 2 then add the value in column k sheet 1 to column B sheet 2

Of course the situation will exist where there are several rows of data in sheet 1 which are for the same course so the answer needs to be a sum function rather than a retrieve value.

I have confused myself to the point where I have no idea what to do now or even if im looking at a formula in sheet or having to resort to VBA!

Any pointers in the right direction will be a greatly appreciated.

[sweep]

Hi,

Have you got an example you can post?

Dave

[Zeke XA3]

Ill try and post what i can

Sheet 1

Please Login or Register  to view this content.

Where Course type is a drop down box in Coloumn C and Amount paid is entered in coloumn K

Sheet 2

Please Login or Register  to view this content.

Where Course code is coloumn C and Total is Coloumn D


What i would like is for the total box to show the amount paid of all the courses of that type, ie in the above example the total for DTS would be 1221 and for DSS 777.

I have got this far to look up the first value, but unsure how to add all matching values.

Please Login or Register  to view this content.

(PS is thre is an easier way to post an example let me know!)

Thanks

[Zeke XA3]

Ohhh i think i may have it,

Please Login or Register  to view this content.

[sweep]

You got it while I was typing!!!!

OK,

Take a look at the sumif function.

In your example, you can do this:

=sumif(sheet1!B:B,"=DTS",sheet1!K:K)

or even

=sumif(sheet1!B:B,sheet2_cell_that_contains_DTS,sheet1!K:K)

[Zeke XA3]

thanks for the help (you always get the answer after you ask for help!), got too caught up in lookup and never used the +sumif before!