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