Summing Up only the Weekend Days from the Total

[mowas]

Dear Excel Experts,

I have a scenarios and am stuck finding out ways to select only the weekend days from a range of dates and sum-up the values corresponding to those weekend days in a separate column.

As you can see in the image, I have column "N" which is adding up the total values of row no. 2 from P2:AS2. I want to exclude the workhours (29 in total) worked on fridays throughout the month from the total hours.

I tried my level but couldn't reach a conclusion, I would greatful if anyone can provide me a solution for this scenario.

Thank you in advance.

 

[Alex Blakenburg]

Try:

=SUMPRODUCT( ($P2:$AS2) * (WEEKDAY($P$1:$AS$1)<>6) )

Where 1 = Sunday and 6 = Friday

 

[mowas]

Try:

=SUMPRODUCT( ($P2:$AS2) * (WEEKDAY($P$1:$AS$1)<>6) )

Where 1 = Sunday and 6 = Friday

Thank you Alex.. It worked and I successfully implemented it at my end... Really appreciate this quick and simple solution which was making me crazy...

 

[Alex Blakenburg]

You're welcome. Glad I could help.