Calculate sum of specific colums

[VeKa27]

Hi you all,

Tried to upload my sample file but did not work.. sorry for that.. I hope my screenshot helps to imagine what i am looking for.
I hav a very big table like in the screenshor (more then 100 products an much more columns for every week.
What i want is this: if i select a day in cell AB3, then i want to see the totals (sum) in cell AB5 for that row and that day. the same formula for row 6 in AB6, row 7 in AB7,...

Hoping for a solution..
Thx

 

[Fluff]

How about
=SUMIF(B5:Z5,AB$3,C5:AA5)

 

[VeKa27]

Hi Fluff,
Great! Your formula works fine.
Thank you for your input. In return i am sending you many many healthy in these times..
Case closed..

 

[Fluff]

You're welcome & thanks for the feedback.