I have a worksheet with a list of transactions of fruit sales. Column A contains a list of transactions with the name of the fruit that was sold and Column B contains the quantity of fruit that was sold in that transaction.
I want to count how many times the variable "Apple" OR
"Pear" are listed within that range.
I want to specify that it's Apple or Pear using a cell with "Apple,Pear" in it (i.e. I want to be able to comma delimit my critera in a cell and then count the number of cells within my Fruit Types range that EITHER of the comma delimited variables are matched.
finally, I want to count the maximum number of items of fruit that were sold in any one matching transaction.
I've attached an example spreadsheet, because it's kinda hard to explain :)