forest1959
New Member
- Joined
- Mar 16, 2010
- Messages
- 30
- Office Version
- 2016
- Platform
- Windows
Good afternoon
On Sheet 1 I have a list of data, in column A i have a persons name, in column B through to F I have dates that the person is on annual leave, there are multiple names with duplicates in column A
On sheet 2 i have a persons name in cell A2 and a specific date in cell B1, I am trying to count how many times that person has the specific date listed
My formula is
=COUNTIFS(Sheet1!A:A,Sheet2!A2,Sheet1!B:F,Sheet2!B1) but its bringing back #VALUE!
=COUNTIF(Sheet1!A:A,Sheet2!A2) brings back the number of times the persons name is in column A and =COUNTIFS(Sheet1!B:F,Sheet2!B1) counts the number of times the date is located in the 5 columns, but they don't work together
Any idvise please
regards
Paul
On Sheet 1 I have a list of data, in column A i have a persons name, in column B through to F I have dates that the person is on annual leave, there are multiple names with duplicates in column A
On sheet 2 i have a persons name in cell A2 and a specific date in cell B1, I am trying to count how many times that person has the specific date listed
My formula is
=COUNTIFS(Sheet1!A:A,Sheet2!A2,Sheet1!B:F,Sheet2!B1) but its bringing back #VALUE!
=COUNTIF(Sheet1!A:A,Sheet2!A2) brings back the number of times the persons name is in column A and =COUNTIFS(Sheet1!B:F,Sheet2!B1) counts the number of times the date is located in the 5 columns, but they don't work together
Any idvise please
regards
Paul