Data sheet is similar to this, each content is not fixed, but the same format
![](https://img.codepudding.com/202009/89995202317331.png)
Then according to the unit and the license plate, the amount of input to the specified below cell
![](https://img.codepudding.com/202009/89995202317332.png)
Then click function after total cell shows, that position shows that there are a few Numbers together, the following figure
![](https://img.codepudding.com/202009/89995202317333.png)
Kneel down for help, can contact me directly QQ 228169654 paid services! Paid services! Paid services!
Really don't know in which section, please help!
CodePudding user response:
Began keeping records in Excel macro, manual, complete the required function end record macros, press Alt + F11 key, check just record macro corresponding VBA code,CodePudding user response:
This hair in VB version, that's right,![](https://img.codepudding.com/202009/89995202317334.gif)
This problem must do, do a few before, such demand is much more complicated than you,
You can pay how much?
![](https://img.codepudding.com/202009/89995202317335.gif)