And see my followup to your response.

Bob Phillips wrote:

There is a missing ), and it doesn't work anyway with the wildcard. See my
response earlier.

--
HTH

Bob Phillips

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

"mama no teeth" wrote in message
...
Try this

=SUMPRODUCT(--(A1:A500={"*due*",""})

"Ani63" wrote:

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