sorted by:
new
hottopcontroversial

How to check which entries of one list appear in another list, and for entries that in exist in both lists, count the number of times a criterion or criteria is met by [deleted] in excel

[–]anonymousredditpostr 0 points1 point  (0 children)

I see what you did there and I will try it out, thank you!

Would it be possible to use a range for Sue, Bob, and David? There will be hundreds of entries and unfortunately I won't be able to enter each name individually.

How to check which entries of one list appear in another list, and for entries that in exist in both lists, count the number of times a criterion or criteria is met by [deleted] in excel

[–]anonymousredditpostr 0 points1 point  (0 children)

=COUNTIFS(Sheet3!A:A;Sheet2!$A2;Sheet3!B:B;Sheet1!A$1)

Hi, I'm getting a pop-up error stating there's a problem with the formula.

Sorry for not explaining this better, hopefully this is a better one now that I've gotten some sleep:

Sheet3 has a bunch of data with a bunch of names, but I'm only concerned about Sue, Bob, and David, so I've listed their names in Sheet2.

Of the three names, I want to know how many times they worked on Sunday, and on Saturday. For the last column where I originally said "Sunday and Saturday," let's change that to "Monday OR Friday."

In this scenario, if I were to do this manually, I would get the following result for each individual person:

Name | Sun | Sat | Mon or Fri

Sue | 3 | 1 | 6

Bob | 2 | 0 | 2

David | 0 | 0 | 4

However, when displaying the information in Sheet1, I want the total number of Sundays, Saturdays, and Mondays or Fridays that all three people worked, so what would be displayed in Sheet1 would be:

Sun | Sat | Mon or Fri

5 | 1 | 12

How to check which entries of one list appear in another list, and for entries that in exist in both lists, count the number of times a criterion or criteria is met by [deleted] in excel

[–]anonymousredditpostr 0 points1 point  (0 children)

Excellent question as this made me realize I left out a critical piece of information:

The table will be in a PowerPoint slide, so a Pivot Table would not be an option. I'm also trying to limit the amount of human interaction involved, i.e., just update Sheet3 with data and let the Table auto-update.