View Single Post
  #1   Report Post  
Mike@Q
 
Posts: n/a
Default SUMIF with more than 1 criteria

Hi

I am trying to sum cells that fulfil either criteria A or criteria B. I have
tried =SUMIF(P:P,A1orB1,G:G). I can not simply add two SUMIF's together as I
need to reduce the length of the overall formula.

Thanks for your help