or more correctly:
=COUNTIFS(Sheet2!A:A,lcase(trim(("yes")),Sheet2!C:C,Sheet1!$A1)+COUNTIFS(Sheet2!B:B,lcase(trim("yes")),Sheet2!C:C,Sheet1!$A1)
the trims and the lcases will help with bad data entry, which might not be necessary if you're not relying on people to follow simple instructions
Posted By: Ralf Scrampton, Jan 16, 12:19:46
Follow Ups
- 1How do trim and lcase work? Not used them before.
Posted By: megson, Jan 16, 12:48:21 - 2^^^ that ain't correct
Posted By: Ralf Scrampton, Jan 16, 12:26:05
Reply to Message
Written & Designed By Ben Graves 1999-2025