You sure?

I started a new workbook and put this in D1 of Sheet1 (no other changes):
=countif(a1:a500,"*due*") + countif(a1:a500,"")

I got 500 back.

Same with:
=sum(Countif(a1:a500,{"*due*",""}))



Bob Phillips wrote:

It should be

=SUMPRODUCT(--((ISNUMBER(FIND("due",A1:A500)))+(A1:A500="")))

Dave, your formula omits cells that have never had a value, only counts
those that had a value then cleared.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ani63" wrote in message
...
I have a cell range that has 3 different types of cells in it. It's about
training, some have date or period when training was completed, some have
"due" plus date or period, and some are blank, yet to be filled. I need to
add the blank cells to the due ones, tried countif but only one criteria
allowed, tried sumproduct (--(A1:A500="*due*"),--(A1:A500="")) didn't work
(value error in part two). How do I add the blanks and the dues together.
Any
help appreciated.

--

Dave Peterson