Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
[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?? |