View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John[_60_] John[_60_] is offline
external usenet poster
 
Posts: 16
Default Help with SUMIF and criteria

I'm building a sheet that lists product units over a twelve month
period. I want to calculate the SUM of the first three months where
there's been activity...find the first cell within the twelve month
range that has a positive units sold value and sum that cell with the
next two adjacent cells, which can be either positive or negative.
(The initial cell must be positive.)

Any tips on how to build this a formula for this are greatly
appreciated!