J
JBoulton
Hi, All!
I've been using a sumproduct like this for several months to analyze
changing data:
=SUMPRODUCT(--(Posting_Date>=$A22),--(Posting_Date<$A23)*(User_Name=F$17))
This counts the number of entries for User_Name that occurred between dates
at A22 and A23.
The range names are established using dynamic range calcs.
Today, my data changed format (column arrangement) so I revised the range
calcs to match the new layout and expected the sumproduct formulas to return
the standard results. However, now the formula produces 0 when it should
have another number.
To make it more interesting I have another workbook with a similar layout
and formula which worked exactly as I expected it would after a similar base
data layout change.
Does anyone have an idea how I can correct the problem?
TIA!
I've been using a sumproduct like this for several months to analyze
changing data:
=SUMPRODUCT(--(Posting_Date>=$A22),--(Posting_Date<$A23)*(User_Name=F$17))
This counts the number of entries for User_Name that occurred between dates
at A22 and A23.
The range names are established using dynamic range calcs.
Today, my data changed format (column arrangement) so I revised the range
calcs to match the new layout and expected the sumproduct formulas to return
the standard results. However, now the formula produces 0 when it should
have another number.
To make it more interesting I have another workbook with a similar layout
and formula which worked exactly as I expected it would after a similar base
data layout change.
Does anyone have an idea how I can correct the problem?
TIA!