M
Michelle
Last week I posted the question below and received a
formula that worked very well [ =SUMPRODUCT(COUNTIF
(INDIRECT(ROW(INDIRECT(B2&":"&C2))&"!
A:A"),A2)) where A2 is unit #, B2 = start date, C2 = end
date.]
However, I now have one additional variable. I am tried
several ways to include it in the formula without
success. The additional variable is a dollar amount.
Please help.
I have a workbook with 32 sheets, 1 - 31; 31 and a SUM tab.
On the sum tab I would like to calculate how many times a
sequence of numbers (ex. 1102, 1235, etc) appears,
however, I do not necessarily want to count it each day of
the month, so on the sum take I have a column for start
date and end date. How do I create a formula that
references the start and end days, then sum every time
that 1102 appears on those days / tabs ( as well as the
dollar amount for that unit)?
Here's an example of how my Sum tab looks:
Unit # Amount Start Date End Date SUM
1102 $19.00 1 15
1235 $14.00 5 10
1511 $18.50 2 22
Thanks again,
Michelle
formula that worked very well [ =SUMPRODUCT(COUNTIF
(INDIRECT(ROW(INDIRECT(B2&":"&C2))&"!
A:A"),A2)) where A2 is unit #, B2 = start date, C2 = end
date.]
However, I now have one additional variable. I am tried
several ways to include it in the formula without
success. The additional variable is a dollar amount.
Please help.
I have a workbook with 32 sheets, 1 - 31; 31 and a SUM tab.
On the sum tab I would like to calculate how many times a
sequence of numbers (ex. 1102, 1235, etc) appears,
however, I do not necessarily want to count it each day of
the month, so on the sum take I have a column for start
date and end date. How do I create a formula that
references the start and end days, then sum every time
that 1102 appears on those days / tabs ( as well as the
dollar amount for that unit)?
Here's an example of how my Sum tab looks:
Unit # Amount Start Date End Date SUM
1102 $19.00 1 15
1235 $14.00 5 10
1511 $18.50 2 22
Thanks again,
Michelle