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 on January 16th 2015 at 12:17:14
Message Thread
- PM YellerLee (General Chat) - Ralf Scrampton, Jan 16, 12:17:14
- Cheers. I worked it out myself in the end - the same as your first example (General Chat) - Yellalee, Jan 16, 12:24:04
- You know Said in OZ (General Chat) - pants, Jan 16, 12:20:07
- yeah, that still doesn't tally in my mind (General Chat) - Ralf Scrampton, Jan 16, 12:28:42
- I vividly remember him in it as well (spoilers if someone is considering watching it) (General Chat) - pants, Jan 16, 12:35:16
- me too, it isn't even like he looks dramatically different either (n/m) (General Chat) - Ralf Scrampton, Jan 16, 12:39:57
- I vividly remember him in it as well (spoilers if someone is considering watching it) (General Chat) - pants, Jan 16, 12:35:16
- yeah, that still doesn't tally in my mind (General Chat) - Ralf Scrampton, Jan 16, 12:28:42
- or more correctly: (General Chat) - Ralf Scrampton, Jan 16, 12:19:46
- How do trim and lcase work? Not used them before. (n/m) (General Chat) - megson, Jan 16, 12:48:21
- trim gets rid of all trailing spaces and leading spaces and double spaces from a text valu (General Chat) - Ralf Scrampton, Jan 16, 14:21:37
- ^^^ that ain't correct (General Chat) - Ralf Scrampton, Jan 16, 12:26:05
- Luckily I've added a validation list to choose from (General Chat) - Yellalee, Jan 16, 12:27:01
- good stuff :-) (General Chat) - Ralf Scrampton, Jan 16, 12:30:46
- Luckily I've added a validation list to choose from (General Chat) - Yellalee, Jan 16, 12:27:01
- How do trim and lcase work? Not used them before. (n/m) (General Chat) - megson, Jan 16, 12:48:21
Reply to Message
In order to add a post to the WotB Message Board you must be a registered WotB user.
If you are not yet registered then please visit the registration page. You should ensure that their browser is setup to accept cookies.