This formula is not working in google docs but does work in excel. Any reasons why?
=SUM(COUNTIFS(A4:S32,"WAC",B4:T32,{"RTC","PHP"}))
This formula is not working in google docs but does work in excel. Any reasons why?
=SUM(COUNTIFS(A4:S32,"WAC",B4:T32,{"RTC","PHP"}))
I can't say why it doesn't work in Google Docs (I'm not familiar with it)
But that is not really a standard use of either of those functions, but it's a neat little trick that works in Excel.
But it's basically just a shortcut for countifs+countifs.
So in google docs, try
=COUNTIFS(A4:S32,"WAC",B4:T32,"RTC")+COUNTIFS(A4:S32,"WAC",B4:T32,"PHP")
I suspect it's because of the array element contained in your formula ({"RTC","PHP"}).
Jonmo1's solution should work though.
I've seen other posts about google docs where they have to use a function called ArrayFormula (or something like that)
So maybe you need to do
=ArrayFormula(SUM(COUNTIFS(A4:S32,"WAC",B4:T32,{"RTC","PHP"})))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks