lundi 24 juillet 2017

Array formula: equals any cell from range

My question is in an array formula, can I return a true/false every time there is a match of a text in one range to another range?

Here is my attempted formula:

=SUM(IF(Table1[Product]=Condor,Table1[Revenue],0))

Condor is my created list. Table1 is my data source. There are matches in the Product column and Condor. Revenue is what I plan on returning when there is a true and have it all summed.

From what I understand, it is not possible to do this with arrays. Is there another way that I do not know of?

Thanks for any input.

Aucun commentaire:

Enregistrer un commentaire