Forum Discussion
Solved
COUNTIFS, counting date range and word
Hello I am trying to create a formula to count the occurrences of a particular month and if an adjacent cell contains Yes Say column A2:A284 are dates dd/mm/yyyy and column R2:R284 contains either...
RE. this gives a result of #value! any other suggestions? NO, this works no problem (sample attached):
==> How to correct a #VALUE! error in the SUMPRODUCT function
Simply try this for countifs,
=COUNTIFS($B$1:$B$10,C1,$A$1:$A$10,">=12/07/2022")
12-07-2022 Yes Yes 7
13-07-2022 Yes
14-07-2022 No
15-07-2022 Yes
16-07-2022 No
17-07-2022 Yes
18-07-2022 Yes
19-07-2022 No
20-07-2022 Yes
21-07-2022 Yes
=COUNTIFS($B$1:$B$10,C1,$A$1:$A$10,">=12/07/2022")
B Column count for Yes
A Column count for equal and greater than 12/07/2022 (Date can be changed according to your needs)
You can able to add multiple conditions for countifs for the same range.
- Thanks, appreciate the help