Forum Discussion
calzadillajessica
Oct 12, 2018Copper Contributor
Help with Countif and Or
Hello! I'm trying to get a total number of people who have completed surveys. Some people complete their surveys after 3 months, the date that they complete their survey is added to a 3 month surve...
Haytham Amairah
Oct 12, 2018Silver Contributor
Hi,
Please try this formula and find it in the attached file.
=COUNTA(B2:B16,C2:C16)-SUMPRODUCT((B2:B16<>"")*(C2:C16<>""))
Hope that helps