How to correct a 2010 Excel VALUE error
Posted on 2012-04-11
I am new to Excel so this is probably a very simple solution, but I cannot figure it out and any help would be greatly appreciated.
Column A Column B Column C Column D
Row 1 Divergence 25 Divergence 10
Row 2 -25 Divergence
Row 3 25 sssssss
Row 4 25 Divergence
I created the following forumla: =COUNTIFS(C1:C4,A1,B1:B4,">D1")
It returns the VALUE error. I think I understand that there are 2 different data types here that is causing the problem, but I cannot figure out how to fix it.
What I am trying to do is find the number of times the word divergence is found with positive value in column B. The answer is 2.