View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Scotts Scotts is offline
external usenet poster
 
Posts: 14
Default Sorting & Calculating

If I have a column sorted by A B C and another respective col that has
numbers in it, how could I write a function that would add up all numbers
that have a respective A in the first col?

In other words I want to Sum (if any cell in col A = A, I want to add them up)

-----------------
Scott