Say i have a report that tells how much fruit ive sold and it's broken down per order per item type, and i want to use a formula that reads the name of the item, the quantity of the item in the corresponding row, and return the total number of that item sold.
EXAMPLE:
Item: qty: price: ext. price:
apple 3 1 3
orange 1 2 2
apple 1 1 1
lime 6 .5 3
apple 4 1 4
I want a formula to return the total number of apples sold in this report. what command/formula will do this?
Bookmarks