Home

Help with Countif and Or

calzadillajessica
Occasional Visitor

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 survey column. Some people complete it after 6 months, and the date is added to a 6 month survey column. Sometimes there will be a date in both columns but I don't want those people counted twice. What formula could I use? 

1 Reply

Hi,

 

Please try this formula and find it in the attached file.

=COUNTA(B2:B16,C2:C16)-SUMPRODUCT((B2:B16<>"")*(C2:C16<>""))

SUMPRODUCT & COUNTA.png 

Hope that helps

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies