Hello,
I am on Sheet2 and want a formula to tell me, How many people are there (names are listed on Sheet 1) on Sheet1 where Column F says "Bloomfield" and Column I says "Orientation".
I tried at first doing CountA and IF, and tried CountIF as well.. Can't seem to crack it.
Thanks!
is this what you are looking for?
=COUNTIFS(Sheet1!A:A,"<>",Sheet1!F:F,"bloomfield",Sheet1!I:I,"orientation")
it is a little unclear about the reference you are making to the names on sheet1
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
YES! Thank you so much!
Can I tack on one more question, expert?
If I want to say, in this same formula, Sheet1 Column I says 'orientation' OR 'xyz', how would I do that?
Again thank you for your super quick and on point response!
make it this...
=SUM(COUNTIFS(Sheet1!A:A,"<>",Sheet1!F:F,"bloomfield",Sheet1!I:I,{"orientation","xyz"}))
Currently doing a happy dance in my office.
Thanks so much Sambo!!!
you're welcome! AND thank you for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks