Linking sheets multiple calculations

Hey guys had some help here for the past few nights great by the way.

Have attached spreadsheet
I'm trying to do the following

If I choose "active" in d5:d109 on Pipeline (name of sheet) and choose Jan or any month in the drop down in k5:k109,i want the value in c5:c109 to be dislayed on sheet2 in C cells under the corresponding month.

Any help would be very grateful

Rhys

Originally Posted by barrfly

i concatenated the month and status in column p. Then used the sumif. see formulas highlighted in yellow

Thanks I'll take a look now....

cheers rhys