lbarraclough
New Member
- Joined
- Sep 29, 2020
- Messages
- 4
- Office Version
- 365
- 2019
- Platform
- Windows
Hi
I’m trying to use a countifs statement and I can’t get it to work.
I have a column of teaching subject names and then a column of data showing the date an assignment was issued.
Is there a way that a countifs statement could count the number of occurances of a date but only if the subject is business studies for example?
I can get the countifs to count the date range in the column I just can’t get it to accept it with adding in the condition of the subject range.
Any ideas?
I’m trying to use a countifs statement and I can’t get it to work.
I have a column of teaching subject names and then a column of data showing the date an assignment was issued.
Is there a way that a countifs statement could count the number of occurances of a date but only if the subject is business studies for example?
I can get the countifs to count the date range in the column I just can’t get it to accept it with adding in the condition of the subject range.
Any ideas?