|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula that looks at more than one criteria and then adds up those that match
I have a spreadsheet with two worksheets
Worksheet 1 for arguments sake assume that in column A is the students name column B the lesson (i.e Math, History, Science etc) So John Smith could be in A1:A10 multiple times for multiple lessons Worksheet 2 So assume the raw data is in this worksheet, and it has Column A as Names Column B is the lesson column C has a number of hours of lessons attended i.e (Worksheet 2) A1 (John Smith) ...........B1 (History) ..........C1 (3) A2 (John Smith) ...........B2 (Math) .............C2 (2) A3 (Bill Jones) ..............B3 (History) ..........C3 (1) A4 (John Smith)............B4 (History) ...........C4 (2) (Worksheet 1) A B C A1 (John Smith) ...............B1 (History) ..............C1=???? A2 (John Smith) ...............B2 (Math) ................. I want to add a formula in Worksheet 1 in cell C1 that says look at Worksheet 2 and any time in Column A you see the name of the person shown in A1 of Worksheet 1 & you also see the contents of Worksheet 1 cell B1 then add the number of hours in Worksheet C1:C10 So for the example above it should return the value of 5 I thought I had it but am lost and very confused. Is it a countifs formula Sumifs or something else. I hope my description makes some sense |
#2
|
|||
|
|||
See the attached.
|
#3
|
|||
|
|||
Great
Thanks for the help, now works as it should
Hooray |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Create a unique list of values that match a criteria, sorted in order of another criteria | BradRichardson | Excel | 2 | 01-03-2017 12:25 AM |
Outlook rule to not send if attachment name doesn't match criteria | SerenityNetworks | Outlook | 10 | 03-20-2016 10:56 AM |
Using a VLOOKUP - when 2 rows match criteria it returns the first value in the cel only how 2 change | djrobst | Excel | 4 | 10-28-2015 01:32 AM |
Count unique values that match 2 or more criteria | caeiro01 | Excel | 1 | 10-25-2015 02:34 AM |
Vlookup or Index/Match - Multiple Criteria | ruci1225 | Excel | 1 | 01-15-2012 07:31 AM |