Hi,
For a friend I'm looking for a solution for the following:
Sheet 1 (prodictlist) has a product list with product code, product name and price.
Sheet 2 is a sales sheet to be used by volunteers entering what they sell for this non-profit organisation.
In sheet 2, we'd like the following:
Column A: The volunteer enters the product code of the item sold
Column B: With a VLOOKUP, the product name is automatically filled out here: No problems.
Column C: Again with a vlookup we want the price to appear here, BUT if the cell in column A is blank, we want the total of the above sales to appear there. On the next line we keep it blank and after that we want the volunteer to start entering data again.
Example:
A B C
QD53 tea 2 euro
QZ33 coffee 2 euro
4 euro
RU87 book 14 euro
AK89 music 11 euro
QD53 tea 2 euro
27 euro
etc...........
The question: When pushing the autosum button, it usually adds the range above it, UNTILL there is a blank. But we don't want to push the autosum button, we want this option to be embedded in the formula. Is there such a formula that SUMS based on RANGE criteria such as "sum untill blank cell". Every cell in this colum should have the SAME formula so the volunteers only need to enter the product codes.
Formula: =IF(ISBLANK(A8);AUTOSUM;(VLOOKUP(A8;Productlist!A:E;5;0)))
Hope someone can help...
Henri
Bookmarks