Thread: SUMIF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Neil Miller Neil Miller is offline
external usenet poster
 
Posts: 1
Default SUMIF

I am trying to calculate the sum of a range based upon 2 criteria but cannot
work out how to do it.

For example, I would like to count the monetary value of a column (A) based
upon a criteria, such as a name, in another column (B) and then assuming it
matches the criteria of another column (C). I can make it do a calculation
based upon the first two but not the third column.

I hope this makes sense if anyone can help???

Thanks.
Neil