I didn't say it was because you didn't array-enter, I said no data met the
condition! And I gave you a formula to prove it.
--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"cj21" wrote in message
...

i do press: CTRL+SHIFT+ENTER

sorry i think i messed up in my explanation. i use many formulas the
sum is one the average is another, i also find the mean, mode etc.
These are all seperate and reported in there own column. The criteria
is right, it has worked before.

However there is a green triangle in the top left corner of the data in
column H and D

Chris


--
cj21
------------------------------------------------------------------------
cj21's Profile:
http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=500178