How to add a sum based on an array formula ?

Options
azerty64
azerty64 ✭✭
in Formulas and Functions

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

· Share on FacebookShare on Twitter

Best Answer

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!