Let Function error

Question

Let Function error

Amr Tawfik 0

User's image

Can anyone advise the reason of this error please ?

Viorel 120.4K Reputation points

2023-02-08T19:45:40.3666667+00:00

Maybe you should give details about other columns (E, F?) that use formulae. And describe the purpose of G.
Emi Zhang-MSFT 28,896 Reputation points Microsoft External Staff

2023-02-20T10:19:15.33+00:00

Hi @Amr Tawfik,

I have not heard back from you in a few days and wanted to check on the status of the problem. If you have any questions with the previous information I've provided, please don't hesitate to let me know. I am glad to be of assistance.

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

1 answer

Your answer

Viorel 120.4K Reputation points

2023-02-08T19:45:40.3666667+00:00

Maybe you should give details about other columns (E, F?) that use formulae. And describe the purpose of G.
Emi Zhang-MSFT 28,896 Reputation points Microsoft External Staff

2023-02-20T10:19:15.33+00:00

Hi @Amr Tawfik,

I have not heard back from you in a few days and wanted to check on the status of the problem. If you have any questions with the previous information I've provided, please don't hesitate to let me know. I am glad to be of assistance.

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 1

Hi @Amr Tawfik,

What the x's value should be? SUM(D2:D30)or D2?

And the SUMIFS(x,y,z), did you want to SUM(x,y,z)? What the p's value should be?

If the result is return p, you can directly SUM(x,y,z)

=LET(x,D2,y,MONTH(E2),z,F2,SUM(x,y,z))

please be a bit more precise to explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

Let Function error

1 answer

Your answer