subtracting numbers to be inclusive

[Jeffrey]

cell A1 starting check number = 1
cell B1 ending check number = 10

=sum(b1-a1) will equal 9

I needs it to equal 10 (total number of checks)

is there a beter way then

=sum((b1-a1)+1)=10

Thanks

 

[Chip Pearson]

You don't need the SUM function. Just use

=B1-A1+1


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com