Ossie,

Thanx, that provided the correct result.
Much appreciated.

- Mik


"OssieMac" wrote:

Hi Mike,

Hope I have understood the question correctly.

Try the following formula. CountIf < zero treats blanks as < zero
therefore need to count the blanks separately and subtract them.

=IF(COUNTIF(D23:O23,"<0")-COUNTBLANK(D23:O23)0,1,0)


--
Regards,

OssieMac


"MikeF" wrote:


This has become quite challenging.

IF in range d23:023 there are only zeros, nothing[s], or a mix of both,
would like cell q23 to return zero, otherwise 1.

Cant use a sum because sometimes there are offsetting numbers, ie +100 and
-100 in the same row that would return 0.
Some cells in the range are a formula [which is why theres a zero], others
are just blank.

The end result is to import a large table into Access, using row q as import
criteria, so Access does not import any rows that are meaningless.
In other words, if *something* is in the row, put a 1 in column q, if there
is nothing meaningful in the row [zeros or nothings] put a zero in column q.

Have tried numerous COUNT IFS formulas to no avail.

Any assistance would be sincerely appreciated.

Thanx,
- Mike