+ Reply to Thread
Results 1 to 4 of 4

Formula for excel is not working in google docs

  1. #1
    Registered User
    Join Date
    08-24-2016
    Location
    California
    MS-Off Ver
    Office 2021
    Posts
    93

    Formula for excel is not working in google docs

    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"}))

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Formula for excel is not working in google docs

    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")

  3. #3
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2021 H: 365
    Posts
    940

    Re: Formula for excel is not working in google docs

    I suspect it's because of the array element contained in your formula ({"RTC","PHP"}).

    Jonmo1's solution should work though.

  4. #4
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Formula for excel is not working in google docs

    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"})))

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Google Docs ()FILTER to Excel
    By royk2341 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-27-2015, 08:46 AM
  2. Vlookup Indirect function working for Apple Numbers and Google Docs but not Excel
    By karisiasafaris in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-16-2015, 06:30 AM
  3. Conditional Formatting with a custom formula help (Google Docs)
    By joynerCN in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 05-02-2014, 07:53 AM
  4. Adding timestamp formula to drop down box on google docs
    By cmcefm in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-27-2014, 09:44 AM
  5. pull certain data from google docs form-produced spreadsheet to other docs
    By MisterCadillac in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 03-11-2014, 04:49 AM
  6. Google Docs - Help with Lookup/Match Formula
    By livifivil in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 06-24-2013, 01:20 PM
  7. Filter command from Google Docs not working on Excel
    By sakau2007 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-03-2010, 12:07 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1