View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
orquidea orquidea is offline
external usenet poster
 
Posts: 132
Default Using macro or other function

Hi

I want to add the values of column A in 2 groups. One total would be adding
the values of the rows that have 20 on the column B and other total would be
adding the values which have 40 on the column B. The result should be 20 -
13 and 40 - 88

A B
2 20
1 40
84 40
6 20
3 40
5 20

Could anyone help me with this issue.

Thanks in advance.

Escarly