View Single Post
  #1   Report Post  
Daniel
 
Posts: n/a
Default Sum of specific cells

How do I return a sum of a range of cells corresponding to a certain criteria

(For example: I want the sum of all cells in A column which have a value in
B colomn:

A B
1 A
3 B
6

- I only want the sum of cells a1, a2 = 4)

Thanks.