I have objects with serial numbers, example 230, 231, 232, 233 ... Is there a function that can count how many object are from 231 to 278 for example. It can be done with subtracting 278 and 231, and adding 1. But I am wondering is there some function to do this because I need it to be more simple.
Thanks a lot!
Hi
Try using =count(A:A), This will count the number of objects or if you wanted a part of the list then =count(A2:A45) or similar
Cheers
Last edited by FoxSeaLady; 04-22-2016 at 10:34 AM. Reason: Afterthought to add info
Thank you a lot on fast response.
That is not exactly what i need.
I want to enter one number in 1st cell and other number in 2nd cell, and 3rd cell should calculate how many numbers are from 1st to 2nd entered number.
Hope this explains better.
Also sorry for my english.
Thanks!
Attach a sample spreadsheet with expected results, remove any sensitive data.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Example is in attached file.
Thanks!
I am not aware of a built in function, other than =e4-d4+1. Why is that simple formula not simple enough, or what about that formula does not work for you?But I am wondering is there some function to do this because I need it to be more simple.
Originally Posted by shg
I attached another example. I need to have sum of multiple "counted numbers". In simple formula when I have all fields filled it's working correct, but it's problem when I have empty fields, like in example attached. Maybe I will solve it with IF function to check for empty field. What do you think about it?
First some algebra:
Formula as given: y=(a12-a11+1)+(a22-a21+1)+(a32-a31+1)+...+(an2-an1+1)
Removing parentheses and rearranging, keeping careful track of signs, you should be able to show that this is equivalent to:
y=a12+a22+a32+...+an2-(a11+a21+a31+...+an1)+n
So, we simply need to sum up all of the "seconds", subtract the sum of the "firsts", then add in the number of pairs. The first two sums can be simple =SUMIF() functions, and the final step is a simple =COUNT() function.
=SUMIF(H3:S3,"second",H4:S4)-sumif(H3:S3,"first",H4:S4)+COUNT(H4:S4)/2
Thanks a lot!
Try
=SUMPRODUCT(((I4:S4+1)*(MOD(COLUMN(I1:S1),2)=1))-(H4:R4)*(MOD(COLUMN(H1:R1),2)=0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks