Looking for a sum,search and match formula

[excel2425]

EXAMPLE.xlsHello, I am looking to have a formula which copies a number that is a result of summing numbers which fall within each month of the year. I will have a seperate formula for each month since they will all be different columns. I am taking this data from a pivot table that extracts from raw data. For simplicity sake I'll say the pivot table is sheet1 and the "report" page is sheet2. I'm looking for "apples, oranges and pears" and need to sum up dates in the format 4/##/#### for the month of april for John. I want this process to be as automatic as possible and have it only sort the 4 in the date so I can use this from year to year. I can paste my criteria into those to make it easier because my descriptions are long. Also if a picture of my actual sheet is easier I can provide that. Thank you in advance for your help and feel free to ask anything to finding a formula easier to make.

[FDibbins]

hi and welcome to the forum

Pictures are pretty much useless, cant edit or work with them, and most members are not inclined to retype your data.

I would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[excel2425]

Thank you very much, I just uploaded a sample. I would also like to mention that sometimes a person does not have one of the fruits, I'm not sure if that will chage the formula though.

[excel2425]

Also if making a macro would be easier thats definately an option so that I can link it to a button and click it to generate the report. Thanks