How to add a sum based on an array formula ?

Hello everyone, I am new to the forum and I am French so please be indulgent when reading it. πŸ˜‰

I allow myself to contact you because I cannot transform a formula that works in Excel:

=SUMPRODUCT((ISNUMBRE(SERACH(D3;TEST!AE:AE)))*1)

So can you help me solve my problem?


Cordialy,

azerty64

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!