COUNTIF and Ignore Blank Cells

[BristolBay]

Im trying to write this formula below to also ignore blank cells. Any help would be appreciated.

=IF(COUNTIF(F$14:F$23;I14);COUNTIF(F$14:F$23;I14);"")

 

[BristolBay]

Here is the final formula to help others:

=IF(LEN(I14)*COUNTIF(F$14:F$23;I14);COUNTIF(F$14:F$23;I14);"")

 

[BristolBay]

I have an additional question. Is it possible to add an additional argument to the formula causing the total count of the QTY field to decrease by one for each Device that has the status of Rejected?

Current formula below:

=IF(LEN(I14)*COUNTIF(F$14:F$23;I14);COUNTIF(F$14:F$23;I14);"")

[/IMG]

 

[mikerickson]

Something like =IF(LEN(I14)*COUNTIF(F$14:F$23;I14);COUNTIFS(F$14:F$23;I14;$E$14:$E23,"<>Rejected");"")

 

[BristolBay]

Works Perfectly, thank you.