Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Better working across workbooks

Certain functions such as COUNTIF and SUMIF give #VALUE errors if they refer to ranges in closed workbooks where as others such as MATCH work perfectly. This often leads to the need for more complex formulae using, for example, SUMPRODUCT (which does work). This needs fixing.

4 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Malcolm G shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base