• 0

[Excel] Not Equal to Range of Values


Question

Hello all,

I am trying to calculate how many times something appears that does not match the word in values B7 though B16. This is what i have and it works great on calculating its value, but when i throw a <> sign in there, it gives me a #Value error:

{=SUM(('FISSA Spreadsheet'!F:F="Completed")*('FISSA Spreadsheet'!J:J=""))}

Instead of the ="", there should be something that says "Not equal to any words that appear in cells B7 through B17". Any help is greatly appreciated.

Cheers.

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.