Other than a Sum Array?

[mitelkm]

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 :

Please Login or Register  to view this content.

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

[zbor]

Howybout:

=SUMPRODUCT((Xoom!$X$3:$X$304=$A69)*(Xoom!$Y$3:$Y$304=C$65))

[daddylonglegs]

COUNTIFS is a possible option too, i.e.

=COUNTIFS(Xoom!$X$3:$X$304,$A69,Xoom!$Y$3:$Y$304,C$65)