Author Topic: Calculate Range in Excel (Read 1025 times)

DJ · « **on:** March 20, 2005, 13:06 »

Hi Folks,

I'm in the middle of a uni assignment and need to calculate the range from a collection of numbers.

For example (this is over simplified)...

If I had the numbers 10,15 and 20 in cells A1 > C1 the range would be 10.

How do I calculate this automatically in Excel. I tried

Code: [Select]


=range(A1:C1)

but it doesn't work. :roll:

Anyone know the correct function to use?

Thanks :wink:

DJ

DJ · « **Reply #1 on:** March 20, 2005, 14:11 »

Its ok, I've worked out a workaround...

Code: [Select]


=(max(A1:C1))-(min(A1:C1))

Still interested if theres an easier way of doing it though!

DJ

TR · « **Reply #2 on:** March 20, 2005, 14:42 »

=SUM(A1:C1)
Might have read your Question wrong :roll:

DJ · « **Reply #3 on:** March 20, 2005, 16:17 »

Thanks TR, but that would give an answer of 45.

I'm looking to calculate the range (difference) between the set of numbers. The highest number minus the lowest number (but they're not in any sort of order).

DJ

TR · « **Reply #4 on:** March 20, 2005, 16:58 »

DJ

Use the "if" command in the calc.

TR · « **Reply #5 on:** March 20, 2005, 17:18 »

COUNTIF will probaly work using the < les than command.