G
Guest
In 1 sheet I have an account register as it appears in a checkbook:
Date, Payee, Classification, Debit, Credit, Balance
In sheet 2 I have columns designated as pay days which is every 2 weeks and
rows designated Classification. The classifications available in sheet 1 are
derived from the row titles in sheet 2 so they are identical.
I want the sum of each transaction for each Classification falling within
the applicable 2 week period in sheet 2 from sheet 1.
I can summarize the Classifications on a monthly basis using SUMIF but I
haven't figured out how to gather data from within a range of dates. I
haven't figured out how to use SUMPRODUCT either, if that is in fact the
correct function to use.
Please help.
Thanks,
Alex
Date, Payee, Classification, Debit, Credit, Balance
In sheet 2 I have columns designated as pay days which is every 2 weeks and
rows designated Classification. The classifications available in sheet 1 are
derived from the row titles in sheet 2 so they are identical.
I want the sum of each transaction for each Classification falling within
the applicable 2 week period in sheet 2 from sheet 1.
I can summarize the Classifications on a monthly basis using SUMIF but I
haven't figured out how to gather data from within a range of dates. I
haven't figured out how to use SUMPRODUCT either, if that is in fact the
correct function to use.
Please help.
Thanks,
Alex