ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   [Pivot Table] Add Value (https://www.excelbanter.com/excel-worksheet-functions/100049-%5Bpivot-table%5D-add-value.html)

Sphenix

[Pivot Table] Add Value
 
http://img206.imageshack.us/img206/5285/untitledub3.gif

I would like to add value from Amount1 + Amount2 = Total (Which the
amount will show at total column)

e.g. 1 + 111 = 112, 1 + 222 = 223, 3 + 333 = 339, 3 + 444 = 447

My problem is certain "Amount1" column is blank and my result will add
with "0" and not "1, 3..."

Anyway to resolve this??



All times are GMT +1. The time now is 02:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com