Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to calculate number ranges
I am trying to calculate how many total numbers appear in a range of numbers.
The first 2 columns would have the beginning and end numbers for the range. If there is only 1 number for the range it would appear in the first column and the second column would be blank. (When I use the formula B1-A1+1 I get a negative number in third column instead of a 1.) Any help would be greatly appreciated. 1500 1504 5 1505 1 1506 1508 3 1509 1 1512 1515 4 1516 1 |
#2
|
|||
|
|||
=IF(B1="",1,B1-A1+1)*ISNUMBER(A1)
"Lori" <Lori @discussions.microsoft.com wrote in message ... I am trying to calculate how many total numbers appear in a range of numbers. The first 2 columns would have the beginning and end numbers for the range. If there is only 1 number for the range it would appear in the first column and the second column would be blank. (When I use the formula B1-A1+1 I get a negative number in third column instead of a 1.) Any help would be greatly appreciated. 1500 1504 5 1505 1 1506 1508 3 1509 1 1512 1515 4 1516 1 |
#3
|
|||
|
|||
Thank you. This is exactly what I needed.
"N Harkawat" wrote: =IF(B1="",1,B1-A1+1)*ISNUMBER(A1) "Lori" <Lori @discussions.microsoft.com wrote in message ... I am trying to calculate how many total numbers appear in a range of numbers. The first 2 columns would have the beginning and end numbers for the range. If there is only 1 number for the range it would appear in the first column and the second column would be blank. (When I use the formula B1-A1+1 I get a negative number in third column instead of a 1.) Any help would be greatly appreciated. 1500 1504 5 1505 1 1506 1508 3 1509 1 1512 1515 4 1516 1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking for function or formula to calculate number that is revers | Excel Worksheet Functions | |||
calculate number of years | New Users to Excel | |||
2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions | |||
calculate month from week number | Excel Worksheet Functions | |||
How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions |