Data Report of values from different sheet

[john.fries]

Hello group. I'm working on a report that needs to add specific values for each month with specific qualifiers from another sheet. Basically, each month I need to filter out and sum the totals of 3 different types of trips from one column within the specific month and total from another sheet.

Column K has the code for the trip type. (trips are coded either O, C or P)

Column H has the dates

Column P has the numeric values I need added

Each sheet is named by customer

I know what I need the formula to do, but I think it's way beyond my skillset to make it happen. Any recommendations would be appreciated.

Thanks!

[rcm]

Dear John.Fries:

It would be very helpful to have a non sensitive sample of the data and the desired output in excel.

[john.fries]

RCM...

thanks for taking a look. I uploaded the file. I appreciate your time and assistance.

[JeteMc]

This proposal requires some changes to Sheet 6 and that the name of the other tab be changed to match the text in cell A3.
1) Column B is populated using O, C and P,
2) The months in row 2 are changed to dates (1/1/18, 2/1/18 ...) and formatted mmmm
Cells D3:O5 are then populated using:

=SUMIFS(INDIRECT($A$3&"!$P$534:$P$579"),INDIRECT($A$3&"!$K$534:$K$579"),$B3,INDIRECT($A$3&"!$h$534:$h$579"),">="&D$2,INDIRECT($A$3&"!$h$534:$h$579"),"<="&EOMONTH(D$2,0))

Let us know if you have any questions.