I have a table of datas that could be filtered.
This is the formula that I typed out:
=COUNTIFS(F2:F141,”Major”,G2:G141,”Archi)
I am trying to see how many Archi are there in Major. But I received an error saying there’s a problem with the formula
I have a table of datas that could be filtered.
This is the formula that I typed out:
=COUNTIFS(F2:F141,”Major”,G2:G141,”Archi)
I am trying to see how many Archi are there in Major. But I received an error saying there’s a problem with the formula
Hi CrackerJack,
Looks like you missed a quote after Archi.
=COUNTIFS(F2:F141,”Major”,G2:G141,”Archi")
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
I missed that out. But it still didn’t work
I managed to solve it.
=COUNTIFS(F2:F141,”Major”;G2:G141,”Archi")
hi crackerjack, seems like your machine having different setting (e.g. semicolon instead of comma)
you might be interested in formula below too which can achieve same result
=SUMPRODUCT(--(F2:F141&G2:G141="MajorArchi"))
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved
Alvin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks