Re: #DIV/0! - why




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?action=getinfo&userid=25673
View this thread: http://www.excelforum.com/showthread.php?threadid=500178

.


Loading