Ted,

The SUMIF function may do what you need.

Here's an example.

In cells A1 through A5 type the numbers 1, 2, 3, 4, and 5 respectively.

In cell A6 try this formula to sum the numbers less than 3 (i.e., 1 and 2).

=SUMIF(A1:A5,"<3",A1:A5)

You can modify it for other results.


"Ted" wrote:

I am trying to get excel to sum totals, but exclude answers that are outside
of a certain range. I can get it to do this by using =IF(Z80.5,Z8,0).
However, I need it to display absolutely nothing in the cells, rather than a
zero because it alters future calculations. Has anyone any ideas please??

Ted