Why is it if i build a SUMPRODUCT formula around existing data in one of
my sheets it works fine, but it won't 'pick up' data from a blank sheet
which then has data dumped into it?
i.e. Sheet 1 has 2 columns of data, product sold and by who.
In Sheet 2 i have 10 columns (B to K) listing the different products
available to sell. Column A has my salesperson's initials (all
unique).
Because i have to keep each days data on a seperate workbook i'd like
to have the formula in place in a template so i can just drop the sales
data in and it calculates how many of which product have been sold by
who. But it only seems to work if i drop the data in and then rebuild
the formula.
Is it something around needing the exact number of rows it should be
comparing, can i not just ask it to look for data in Column B for
example?
Hope someone can help!
--
penri0_0
------------------------------------------------------------------------
penri0_0's Profile:
http://www.excelforum.com/member.php...o&userid=28947
View this thread:
http://www.excelforum.com/showthread...hreadid=548970