View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
pdberger pdberger is offline
external usenet poster
 
Posts: 258
Default how do sum a column only if meets the criterias of 2 columns

Lorenzo --

Not sure from your question -- do you mean compute the sum of cells in rows
where two other criteria are met? Or compute a sum of all rows if two
criteria are met (otherwise, do something else).

"Lorenzo" wrote:

I would like to sum a column only if meets the criteria of one and another
column.
what formula should i be using? i was using sumif but this is for the
criteria of one column.