Summing rows based on criteria in another column

  • Thread starter Thread starter reybie
  • Start date Start date
R

reybie

I'm trying to consolidate rows of data based on the ID and OP column. In
the attached image, I would like to consolidate ID # 190 because OP
column is blank or zero and leave the other rows of data as is if there
is a value in the OP column.


+-------------------------------------------------------------------+
|Filename: excel problem.gif |
|Download: http://www.excelforum.com/attachment.php?postid=4732 |
+-------------------------------------------------------------------+
 
Back
Top