FAO: Excel pendants, help me out please
I want to get a count of text "yes"s in two different columns (Sheet 2, Columns A and B) if the date in Sheet 2 column C matches the one in sheet 1 cell A1.
I'm sure I need some sums and countifs in there, but I'm not coming up with the magical formula, as it were.
Help me out please!
Posted By: Yellalee on January 16th 2015 at 10:45:25
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.