You need an OR, like this?
=IF(Sheet2!$C1=Sheet1!$A1,OR(COUNTIF(Sheet1!$A1:$A3,"yes"),COUNTIF(Sheet1!$B1:$B3,"yes"),"FAIL")
Posted By: trafford_canary on January 16th 2015 at 11:43:18
Message Thread
- FAO: Excel pendants, help me out please (General Chat) - Yellalee, Jan 16, 10:45:25
- This should work (General Chat) - lurd, Jan 16, 11:15:17
- I'll give it a go, cheers... (n/m) (General Chat) - Yellalee, Jan 16, 11:19:45
- It's not liking it... (n/m) (General Chat) - Yellalee, Jan 16, 11:26:41
- Or rather, it's not returning what it should (General Chat) - Yellalee, Jan 16, 11:27:40
- You need an OR, like this? (General Chat) - trafford_canary, Jan 16, 11:43:18
- No you don't. Swap the OR for and AND? (n/m) (General Chat) - trafford_canary, Jan 16, 11:44:58
- I'll try that (General Chat) - Yellalee, Jan 16, 11:46:55
- Forget the or and the and, do 3 column. 2 COUNTIFs and a SUM column. Easy peasy. (n/m) (General Chat) - trafford_canary, Jan 16, 11:48:55
- Yeah I may just do that. Cheers (n/m) (General Chat) - Yellalee, Jan 16, 11:51:27
- Forget the or and the and, do 3 column. 2 COUNTIFs and a SUM column. Easy peasy. (n/m) (General Chat) - trafford_canary, Jan 16, 11:48:55
- I'll try that (General Chat) - Yellalee, Jan 16, 11:46:55
- No you don't. Swap the OR for and AND? (n/m) (General Chat) - trafford_canary, Jan 16, 11:44:58
- hmm. (General Chat) - lurd, Jan 16, 11:41:20
- You need an OR, like this? (General Chat) - trafford_canary, Jan 16, 11:43:18
- Or rather, it's not returning what it should (General Chat) - Yellalee, Jan 16, 11:27:40
- It's not liking it... (n/m) (General Chat) - Yellalee, Jan 16, 11:26:41
- I'll give it a go, cheers... (n/m) (General Chat) - Yellalee, Jan 16, 11:19:45
- Do you need two new columns, one for (General Chat) - Arizona Bay, Jan 16, 10:51:02
- I think it can be simpler than that, but I just can't pinpoint it (n/m) (General Chat) - Yellalee, Jan 16, 10:56:45
- Yeah, I'm sure you could do it in one column, if you had the Excelfu. (General Chat) - Arizona Bay, Jan 16, 11:05:24
- I think it can be simpler than that, but I just can't pinpoint it (n/m) (General Chat) - Yellalee, Jan 16, 10:56:45
- Penfaces, even... (n/m) (General Chat) - Yellalee, Jan 16, 10:45:44
- Dammit, I'm standing down. Got excited for a minute as I am a professional pedant. (n/m) (General Chat) - Pixelman, Jan 16, 10:53:42
- it's pendants actually (General Chat) - Tombs, Jan 16, 11:05:14
- Dammit, I'm standing down. Got excited for a minute as I am a professional pedant. (n/m) (General Chat) - Pixelman, Jan 16, 10:53:42
- This should work (General Chat) - lurd, Jan 16, 11:15:17
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.