View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Question
 
Posts: n/a
Default SUMIF with multiple criteria, by columns

I have seen the answers to similar questions which suggest the use of
SUMPRODUCT. I have also seen mention that this works for exact and equal
ranges, but i need to do this for columns, because i will be continuously
adding to the ranges.

My columns are named ranges (month, fce1A, SpEE). Here is the sumif
statement.

=SUMIF(AND(month = "Mar 2006", fce1A = true),true,SpEE)