Re: #DIV/0! - why

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


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

.

Relevant Pages

  • Re: Why is sum faster than builtin( sum )
    ... There isn't any code in my sum function. ... What version of Matlab do you have? ... Elapsed time is 0.953000 seconds. ... profile viewer %% 1.033sec ...
    (comp.soft-sys.matlab)
  • Re: Why is sum faster than builtin( sum )
    ... There is an if statement in sum for the output. ... On my Windows box I get about 0.5 seconds for R2006b, ... Elapsed time is 14.609000 seconds. ... profile viewer %% 1.033sec ...
    (comp.soft-sys.matlab)
  • Re: Counting # of days between 2 dates excluding Fri & Sat)
    ... I mean, yeah sure, I know what INT, MOD, SUM and WEEKDAY do. ... You subtract this from that then add this then subtract that and divide by ... this but what kind of an explanation is that? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Lennys 1965 Mahler 1 Posted
    ... > Here's an explanation that I saw elsewhere and thought was an excellent ... > and write that sum on another piece of paper. ... > cabinet and leave the paper with 3 numbers on my desk. ... I go to the file cabinet, retrieve the piece of paper ...
    (rec.music.classical.recordings)
  • Re: Rachels Place II
    ... I wrote in the other profile my other handle, and a brief explanation. ... added in "the other profile" and it messes up the flow. ... (p.s. i caught a lot of mistakes reading over yesterday, ...
    (rec.music.dylan)