T
TrainingGuru
I am using the following formula to count the number of times "Web" appears
in column B based on "1" being in column D:
=IF('List of Reviews'!B:B="Web",COUNTIF('List of Reviews'!D,1),0)
I continue to get a #NUM! error for the logical test in the IF statement
even when the formula is reversed and I try to count the number of times
"Web" appears for every row which contains a "1" in column D. What is wrong
with the formula? Is there another function that will return the correct
result? Just a note: The COUNTIF function works each time to find the right
value for the criteria entered. Help needed quickly! Thanks.
in column B based on "1" being in column D:
=IF('List of Reviews'!B:B="Web",COUNTIF('List of Reviews'!D,1),0)
I continue to get a #NUM! error for the logical test in the IF statement
even when the formula is reversed and I try to count the number of times
"Web" appears for every row which contains a "1" in column D. What is wrong
with the formula? Is there another function that will return the correct
result? Just a note: The COUNTIF function works each time to find the right
value for the criteria entered. Help needed quickly! Thanks.