|
|
#1
07-15-2014, 06:03 AM
|
|||
|
|||
Adding up cells if value equals
Please help regarding a problem in Excel.
I need to add upp the total sum Kr for all columns of type 1. What is the correct formula for this if the kr is to be summed up from C4:O39 and the Type row is between P:4:P39? Many thanks ! K areakrkrkrkrtype 100 kr 2 type 100 2 type 100 1 type 200 1 type 200 1 type Last edited by Kh1978; 07-15-2014 at 10:42 AM. Reason: added an excelfile 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Cell equals zero or another cell in IF statement | dirtboy | Excel | 3 | 06-20-2014 01:44 PM |
 how to keep text format when adding new cells?
|
hotmud | Word Tables | 1 | 09-29-2013 06:12 PM |
|
How-TO format cells (FILL) by comparing cells
|
zanat0s | Excel | 1 | 07-03-2012 04:27 AM |
|
Using (adding) different cells
|
geoff | Excel | 3 | 11-23-2011 01:20 AM |
| Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode