View Single Post
 
Old 09-02-2021, 06:38 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Quote:
Originally Posted by ganesang View Post
Sorry again that number 1127 may be come in any length like 987 etc

What will do in this case?
In case such entries, which contain this short number, are always grouped together, see attached!

In case some of such numbers must be grouped, and some not - I think you'll have to calculate all of it manually!
Attached Files
File Type: xlsx Excel function help_sumif.xlsx (13.6 KB, 7 views)
Reply With Quote