The same number of species in the summary table
Users questions: The following table 10, table 11 under the table in the next 12 in January, February, March, the amount can not increase.
Experts answer:: 1, the original one in B3 enter the formula to strike a number of 201 in January, but due to the limited number of cells that display the character without fruit, it will be divided into the number 201 in January B3 And B4 were calculated, and B4 to be together; January 202 and 203 with this. 2, copy B3: B4, paste it into B5: B6, B7: B8, you can get B3: B8 data; select B3: B8, copied to the right column M, the data can be obtained on the table. This approach is not simple to You thought it a reference. Annex: Table with the variety of requirements and more. Rar