IF function

K

KellyMcG03

I have this formula in my worksheet, it keeps returning "-#VALUE!-"

=IF(I2:I224="x","",IF(J2:J224="x","",COUNTIF(M2:M224,"ship")))

When I go to "Show calculation steps it shows that the error is in th
'I2:I224'

Is it possible to use the "IF" function when including a range of cell
such as 'I2:I224'
 
D

dcronje

The problem could be that this is an array formula and needs to b
entered with Ctrl & Shift keys.


goto the cell with the formula in and press F2 then hold down th
Ctrl+Shift keys and hit Enter.


The formula should now work.

Hope this works/helps
 
P

Pete

You want to either write a blank based on a test in column I, or determine a
count of the number of occurrances of "ship" in Column M if Column J has an
"x". Is that it? If so, why not just copy a formula like the following
down another column starting in row 2, and copy it down to row 224:

=IF(I2="x","",IF(J2="x","",if(m2="ship",1,"")))

Then in row one of this new column, write sum(m2:m224) and you have the
count you are looking for.

Regards,
Pete
 
Top