Notifications
Clear all
Topic starter
I am trying to figure out what is the excel formula to count when there are two distinct criteria (pulling from two columns). I have tried =countif(a1:d59,”123” & “ABD”). It did not work.
Basically, I want to count the number of titles by unit. Can you help?
Thanks
| Title | Unit | Month |
| 123 | ABC | 9/6/2017 |
Posted : 10/11/2017 5:27 pm
It would have helped me when you showed some more data. The countif works slightly different from the way you approach it.
It counts the number of units when they fit to the given criterium: COUNTIF(b2:b59,"ABC")
So I don't see the combination with the title column in this case.
Maybe you can clearify or give some more data?
Posted : 10/11/2017 6:37 pm
I would consider using a Pivot Table.
Posted : 10/11/2017 7:21 pm
=COUNTIFS(A:A,E2,B:B,F2)
=SUM((A2:A14=E3)*(B2:B14=F3)),apply Ctrl+Shift+Enter
Posted : 20/11/2017 10:08 am
Topic starter
Thank you
Posted : 20/11/2017 11:57 am
