software

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

Assuming your data withe headers is in Sheet1:A1:F999
Summary in sheet2 has date Column heders and Classification Row headers
Sheet2 has dummy column header in col A

=SUMPRODUCT((Sheet1!$A$2:$A$999lt;=B$1)*(Sheet1!$A$2 :$A$999gt;A$1)*(Sheet1!$C$2:
$C$999=$A2)*(Sheet1!$E$2:$E$999-Sheet1!$D$2:$D$999))

See example: cjoint.com/?ejkq1bSSPG

HTH
--
AP
quot;Alexquot; gt; a écrit dans le message de
...
gt; In 1 sheet I have an account register as it appears in a checkbook:
gt; Date, Payee, Classification, Debit, Credit, Balance
gt;
gt; In sheet 2 I have columns designated as pay days which is every 2 weeks
and
gt; rows designated Classification. The classifications available in sheet 1
are
gt; derived from the row titles in sheet 2 so they are identical.
gt;
gt; I want the sum of each transaction for each Classification falling within
gt; the applicable 2 week period in sheet 2 from sheet 1.
gt;
gt; I can summarize the Classifications on a monthly basis using SUMIF but I
gt; haven't figured out how to gather data from within a range of dates. I
gt; haven't figured out how to use SUMPRODUCT either, if that is in fact the
gt; correct function to use.
gt;
gt; Please help.
gt;
gt; Thanks,
gt; Alex
Thank you. I don't understand it exactly but it works and that's good enough
for me.

quot;Ardus Petusquot; wrote:

gt; Assuming your data withe headers is in Sheet1:A1:F999
gt; Summary in sheet2 has date Column heders and Classification Row headers
gt; Sheet2 has dummy column header in col A
gt;
gt; =SUMPRODUCT((Sheet1!$A$2:$A$999lt;=B$1)*(Sheet1!$A$2 :$A$999gt;A$1)*(Sheet1!$C$2:
gt; $C$999=$A2)*(Sheet1!$E$2:$E$999-Sheet1!$D$2:$D$999))
gt;
gt; See example: cjoint.com/?ejkq1bSSPG
gt;
gt; HTH
gt; --
gt; AP
gt;
gt;
gt;
gt; quot;Alexquot; gt; a écrit dans le message de
gt; ...
gt; gt; In 1 sheet I have an account register as it appears in a checkbook:
gt; gt; Date, Payee, Classification, Debit, Credit, Balance
gt; gt;
gt; gt; In sheet 2 I have columns designated as pay days which is every 2 weeks
gt; and
gt; gt; rows designated Classification. The classifications available in sheet 1
gt; are
gt; gt; derived from the row titles in sheet 2 so they are identical.
gt; gt;
gt; gt; I want the sum of each transaction for each Classification falling within
gt; gt; the applicable 2 week period in sheet 2 from sheet 1.
gt; gt;
gt; gt; I can summarize the Classifications on a monthly basis using SUMIF but I
gt; gt; haven't figured out how to gather data from within a range of dates. I
gt; gt; haven't figured out how to use SUMPRODUCT either, if that is in fact the
gt; gt; correct function to use.
gt; gt;
gt; gt; Please help.
gt; gt;
gt; gt; Thanks,
gt; gt; Alex
gt;
gt;
gt;