Providing a monthly total

[R0bperry]

I am having trouble finding the correct formula(s) to fix my problem. I probably need multiple formulas in multiple cells but thats fine. I want to total by month and have the amounts reported at the top of the page in specific cells.

My process:
I enter an amount and date in two cells of a table and I do this for the entire page going down. The workbook page will only change annually, but will contain all entries for the whole year.

I want to show a monthly total between two monthly dates, the 16th of month A and the 15th of month B.
(Ex: I have multiple entries that fall between the 16th and 15th: The inclusive dates for the first set are between June 19 and July 10, the second set between July 16 and Aug 12, the third set ect...)

I then want this total to be posted by month at the top of my workbook in a specific cell. These cells will not change location even though they are pulling data from multiple locations on the table.

Any help you can give me will help.

Thanks

Robert

 

[Michael M]

Hi and welcome to the Board
Try something like

=SUMPRODUCT(--(A2:A100>A22),--(A2:A100 < A27)*(B2:B100))

Where A2:A100 is your date list, A22 and A27 are you low date and high date
and B2:B100 is the range of amounts to sum from.