Summing rows based on criteria in another column

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 |
+-------------------------------------------------------------------+
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

please help: find nonblank cell in group of cells... 2
How to vary shading of groups of rows, based on change in value in aparticular column 9
Is it possible to assign rows for exclusion when data is sorted by column? 2
Summing based upon condition 4
Filter out rows based on the value of a cell 4
Locate text in range (multiple occurrences) and report other cell insame column? 10
Rows to columns 1
Assigning a points scoring system 2

Top