Hello All,

Hoping someone can help me with this.. (Here's an exmple)

I am trying to count the number of apples, pears & bananas in column I based on the amount they are sold for(Column E) and bring back the value of apples, pears & bananas based on their sell price without using an array.

Currently I have :
={SUM((Xoom!$X$3:$X$304=$A69)*(Xoom!$Y$3:$Y$304=C$65))}
The formulas works fine via my pc, but not on my android tablet. The android will not accept the array ""{}"".

Someone please help!!

Thank you all