fAlCoNNiAn Posted June 25, 2009 Share Posted June 25, 2009 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 More sharing options...
0 JamesCherrill Posted June 27, 2009 Share Posted June 27, 2009 Have a look at the countif function, maybe what you need. Link to comment Share on other sites More sharing options...
Question
fAlCoNNiAn
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