View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default formula to work with Sumif

=if(A2=criteria,sumif(),whatever you want it to show if doesn't fit criteria)

"Sandy@law" wrote:

I need a formula that will look at column A and if meets the criteria then do
a SumIf based on two other columns with another criteria.