how can I SUM a variable number of cells from 1 to 52?

Hello, I need some help. I have to sum up to 52 week in one cell if on if the cell are identical then bring N/A. I was trying with the conditional if, but it stop in the condtion week 24. here a example that I did:

IF ($C$1=$K1, K2, IF($C$1=$L1, SUM(K2:L2, IF($C$1=$M$1,SUM(K2:M2………. And so on, just to IF ($C1=$BW1, SUM(K2:BW2).

Please I have to solve this problem as soon as posible. I will acept all recomenation.

Regards

Hi, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )

Please change your thread title as requested by the Forum Administrator. Then I can provide a solution.

Maybe "how can I SUM a variable number of cells from 1 to 52”