|
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#1
04-24-2014, 08:41 PM
|
|||
|
|||
Data analysis with four conditions then copies certain values that meets the criteria
i wanna ask, how to come up with this set of criteria and the answer/formula should be on column K ... the blue lined represents on column K as: K3 =SUM(D3,F3,H3,J3) K4 =SUM(D4,F4,H4,J4) K5 =SUM(D5,F5,H5,J5) K6 =SUM(D6,F6,H6,J6) the red lined represents the criteria as >13.5 and if the cell meets that criteria, the entire row [in yellow lined] will automatically copy to another sheet but leaves blank with <13.5 data thanks in advance ... 
|
|
|
| Tags |
| condition, copy, criteria |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| transpose values based on mulitple criteria | mlttkw | Excel | 1 | 12-06-2013 02:00 AM |
 How to take the sum of every value that meets two conditions
|
CrabApple | Excel | 2 | 08-30-2012 11:36 AM |
| Change values in cells based on criteria | SaneMan | Excel Programming | 2 | 02-02-2012 07:58 AM |
|
Using Conditions to Add Values
|
EclipticalD | Excel | 1 | 07-08-2010 09:50 PM |
| Setting up Analysis Sheet when data does not exist, yet. | burnoutdetective | Excel | 0 | 10-13-2008 05:57 AM |
Windows 7 32bit 
Office 2010 32bit
Linear Mode
