This should work

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

Posted By: lurd on January 16th 2015 at 11:15:17

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
        
        hmm. (General Chat) - lurd, Jan 16, 11:41:20
- 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
- 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

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.