View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dale[_11_] Dale[_11_] is offline
external usenet poster
 
Posts: 6
Default Conditional formulas

I'm currently summing a column of numbers using the
following formula:
=sumif(BA23:BA500,"y",N23:N500)

I would now like to break down the sum based on a second
condition ie. only sum the column cells where the above is
true and where the value of the cells in another column
equals 0 or 1 or 2 etc.
What I'm trying to do is derive subtotals of the sum above
based on the revision level where the BA cells are set
to "y". Does anyone have a suggestion?