View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sphenix Sphenix is offline
external usenet poster
 
Posts: 6
Default [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??