Thread: [Solved] Adding up cells if value equals
View Single Post
 
Old 07-15-2014, 06:03 AM
Kh1978 Kh1978 is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: May 2014
Posts: 4
Kh1978 is on a distinguished road
Default 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
Attached Files
File Type: xlsx Excel ex.xlsx (8.9 KB, 10 views)
Last edited by Kh1978; 07-15-2014 at 10:42 AM. Reason: added an excelfile
Reply With Quote