This should work

=IF(C1=Sheet1!$A$1,COUNTIF(A1:A3,"yes")+COUNTIF(B1:B3,"yes"),"")

Posted By: lurd, Jan 16, 11:15:17

Follow Ups

8
I'll give it a go, cheers...
Posted By: Yellalee, Jan 16, 11:19:45

Reply to Message

Written & Designed By Ben Graves 1999-2025