View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
something68 something68 is offline
external usenet poster
 
Posts: 38
Default Two totals in one cell shown in two separate columns

Column A, row 8 shows: A, S
Column A, row 9 show: 1.0, 7.0

I would like Column M, row 9 to show: 1 (total of all "A" shown in row 8)
I would like Column O, row 9 to show: 7 (total of all "S" shown in row 8)