Adding Number Of 'YES' Cells For Rows Of The Same Date

**Hurg** · 06-18-2020, 04:48 AM

I have attached an example sheet.

Each row starts with today's date in cell A followed by a series of yes/no cells.

In a separate tab of the work sheet I want to automatically show the number of yes/nos of each column for each day.

Hurg

**bebo021999** · 06-18-2020, 04:53 AM

Try in B2:

Please Login or Register  to view this content.

Drag down and accross

**alansidman** · 06-18-2020, 05:02 AM

In B2, =COUNTIFS(Input!$A$2:$A$6,Auto.!$A2,Input!B$2:B$6,"YES") and copy right and down.

**Hurg** · 06-18-2020, 05:24 AM

Thank you, they both work great

Hurg

Adding Number Of 'YES' Cells For Rows Of The Same Date

LinkBack

Thread Tools

Rate This Thread

Display

Adding Number Of 'YES' Cells For Rows Of The Same Date

Re: Adding Number Of 'YES' Cells For Rows Of The Same Date

Re: Adding Number Of 'YES' Cells For Rows Of The Same Date

Re: Adding Number Of 'YES' Cells For Rows Of The Same Date

Thread Information

Users Browsing this Thread

Similar Threads

Persistent unique number/row number even after adding and deleting rows.

how to have table insert formulas into cells when adding rows by adding data

Counting the number of matched cells and adding it to a different number...

Adding a number of months to a start date to obtain an 'end date'

Date calculations - adding number of days to a date

adding a number to a date.

Adding Set number of rows according to cell value

Bookmarks

Bookmarks

Posting Permissions