If Weekend Day, Count Another Cell

Hi everyone,

This one is puzzling me, am sure I may have found the solution @ one stage but am losing my mind here lol
I want to check if cells belong to a weekend day, if they do I want to count the content of another cell ie:

A1:I9 is the days of a roster (Fri,Sat,Sun,Mon,Tue,Wed,Thu,Fri,Sat,Sun,Mon,Tue)
In A2:I2 is the number "1" for days I am rostered on,
If upper cells equal a weekend day, I want to check to see if a "1" is in the cell below, if so count it!

example.jpg

Any Help is much appreciated & I thank you in advance,
Chad

As per your example screenshot, try,

Formula:

Please Login or Register  to view this content.

** This is an array formula, confirm it by pressing Ctrl+Shift+Enter after entering the formula into an adjacent cell and copy down for all rows

Here's attachment:

Please Login or Register  to view this content.

Edit: Just realised the formula I was going to use was only ever going to count the weekdays & not the "1" in the cells below

To attach a Workbook
(please do not post pictures of worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"