PM YellerLee

hare goo:

=COUNTIFS(Sheet2!A:A,"yes",Sheet2!C:C,Sheet1!$A1)+COUNTIFS(Sheet2!B:B,"yes",Sheet2!C:C,Sheet1!$A1)

Posted By: Ralf Scrampton, Jan 16, 12:17:14

Follow Ups

Cheers. I worked it out myself in the end - the same as your first example
Posted By: Yellalee, Jan 16, 12:24:04
3
You know Said in OZ
Posted By: pants, Jan 16, 12:20:07
5
or more correctly:
Posted By: Ralf Scrampton, Jan 16, 12:19:46

Reply to Message

Written & Designed By Ben Graves 1999-2025