Thread: SumIf Function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default SumIf Function

Jay

look at SUMPRODUCT

Look at the Help and search the Archives for examples

Regards

Trevor


"jayceejay" wrote in message
...
I'm trying to use the SumIf Function (as I understand its use) and I keep
running into the same problems -- in many cases I have more than one
criterion for addind a specific cell. Is there a way to modify SumIf to
allow for multiple criteria? I try to do it in the insert function box
and
it gets spit back out at me. Any ideas?

Jay