1
excel file
pivottable screenshot
I have an Excel spreadsheet (above, with screenshot). There are three columns of data, A, B, and C. A fourth column, Combined, simply contains a formula that SUMs A and B (=SUM(B2:C2), etc). I want the pivottable to display value columns for:
count of non-zero rows in Combined
sum of rows in Combined
count of non-zero rows in C
sum of rows in C
Everything works except the first. I want it to display the data in column N, but I can't figure out how to either:
Sum together the counts of A and B
or get counts for Combined that don't take the 0 rows into account.
You can directly upload images to this question. – user300375 – 2016-03-01T06:32:12.993