Only Countif value in cell A matches cell B ?
[Closed]
Report
Spike

Derek 
Derek 
Related:
 Suppose cell c5 contains the formula =b$6+c1. match each formula with its respective cell if you copied it.
 Suppose cell c5 contains the formula =b$6+c1  Best answers
 Suppose cell c5 contains the formula  Best answers
 Formula to copy 1 cell by number in another ✓  Forum  Office Software
 Comparing columns and returning value ✓  Forum  Excel
 Excel formula if cell contains text then return value in another cell ✓  Forum  Excel
 The result of a formula in a cell is the *  Forum  Excel
 How to copy cells from one sheet to another in excel using formula  HowTo  Excel
5 replies
venkat1926
 Posts
 1864
 Registration date
 Sunday June 14, 2009
 Status
 Contributor
 Last seen
 August 7, 2021
download sample file from
https://authentification.site/files/24435350/derek.xls
see the formula in F14
https://authentification.site/files/24435350/derek.xls
see the formula in F14
venkat1926
 Posts
 1864
 Registration date
 Sunday June 14, 2009
 Status
 Contributor
 Last seen
 August 7, 2021
For your question "if Cell C:C has any values of less than <0"
=COUNTIF(C:C,"<0")
note the quotations marks.
Let me rephrase your second question
Count if the following conditions are satisfied
Col c is <0
Col C is equivalent to corresponding value in the same row but in column I
The third condition is not clear. Should it not be "<>#N/A"
Why this condition. needs clarification
for multiple conditions use sumproduct function
try this type of formula
=SUMPRODUCT((C1:C16<0)*(C1:C16=I1:I16))
modify t suit you particularly the last row C16 and I 16
=COUNTIF(C:C,"<0")
note the quotations marks.
Let me rephrase your second question
Count if the following conditions are satisfied
Col c is <0
Col C is equivalent to corresponding value in the same row but in column I
The third condition is not clear. Should it not be "<>#N/A"
Why this condition. needs clarification
for multiple conditions use sumproduct function
try this type of formula
=SUMPRODUCT((C1:C16<0)*(C1:C16=I1:I16))
modify t suit you particularly the last row C16 and I 16
venkat1926
 Posts
 1864
 Registration date
 Sunday June 14, 2009
 Status
 Contributor
 Last seen
 August 7, 2021
that sumproduct formula of yours is not correct
what is after all @N/A. This is error due to some formula
if you have some of coloumnA is negative, positive and error as mentioned above
when you want to count only negative that will not take into account positive and also error .
see the following sample data
13
12
5
2
5
#N/A
4
0
3
8
#N/A
11
the #N/A are error values due to a vlook up formula
if you type the following formula it will give you 3 which is correct
=COUNTIF(C1:C12,"<0")
in count if formula the condition is within apostrophes .
the sumproduct formula does not have these double quotes unless it is a text ( a string )
Still if there is some glitch post your data ( a small extract) and that will be looked into.
what is after all @N/A. This is error due to some formula
if you have some of coloumnA is negative, positive and error as mentioned above
when you want to count only negative that will not take into account positive and also error .
see the following sample data
13
12
5
2
5
#N/A
4
0
3
8
#N/A
11
the #N/A are error values due to a vlook up formula
if you type the following formula it will give you 3 which is correct
=COUNTIF(C1:C12,"<0")
in count if formula the condition is within apostrophes .
the sumproduct formula does not have these double quotes unless it is a text ( a string )
Still if there is some glitch post your data ( a small extract) and that will be looked into.