Excel report data statistics questions

With the pivot table, put the name of the drug in the column field, and the quantity and amount in the value area.

Select all cells, Data - Classification Summary, Classification Field - Drug Name, Summary Method - Summation, and select Summary Item - Quantity and Amount.

=sum(sumifs(sole proprietorship!) p:p, sole proprietorship! i:i,, individual business! ag:ag,))

There is no problem with your formula, the problem is that the actual effect of this formula may not meet your needs, and the final effect of this announcement is to count the sum of cells in column p that meet the two conditions of "collateral and subordinate" and "pledged and suspicious", so the statistics will be missing and less, because the conditions only produce these two kinds of one-to-one.

And not the relationship of the x Cartesian product that you want.

You can change it like this.

=sum(sumifs(sole proprietorship!) p:p, sole proprietorship! i:i,, individual business! ag:ag,))

or =sum(sumifs(sole proprietorship!) p:p, sole proprietorship! i:i,, individual business! ag:ag,))

Separate one of the conditions with a semicolon, so that there will be 6 conditions 2x3, that is.

Mortgage subordinated. Suspicious mortgage.

Collateral losses. Staking subordinate.

Suspicious stake. Staking losses.

From an operational point of view, there should be no problem with the formula itself, and the error in the statistical data should be that your data statistics requirements do not match this formula, or the data is in text format.

You still have to provide specific data structure diagrams and data examples, otherwise it is impossible to know the true intent of your statistics.

Try it down=sumproduct(sumifs(sole proprietorship!) p:p, sole proprietorship! i:i,, individual business! ag:ag,))

I'll answer. Share a report.

For example: J Column Y Column Z Column AA.

1 Teacher Personal Income Teacher Total.

2 x 3 10 (Equation 1) (Equation 2).

3 Levil 4:20

4 cards three 10

5 Kings II 30

6 Kings II 10

Enter Equation 2:1 in y1

index(j:j,min(if((j$2:j$1000<>0)*(countif($z$1:

z1,j$2:j$1000)=0),row(j$2:j$1000),4^8)))

This is an array formula, which needs to be determined by pressing the Ctrl+Shift+Enter three-key combination.

Enter Formula 2: in z2

sumif(j:j,z2,y:y)

Select y2:z2 drop-down to fill in.

When you want to calculate the results in Excel, you need to make a formula for the function first. The specific situation, I don't know if you need a sum or something else, it's not very clear.

Still don't understand what you mean. QQ me.。。 490649021

Don't see what you mean?

Whether to arrive at personal income tax or the sum of all income.