Microsoft Office Forums Adding up cells if value equals
 Register FAQ Search Today's Posts Mark Forums Read

#1
07-15-2014, 06:03 AM
 Kh1978 Windows 7 32bit Office 2010 32bit Novice Join Date: May 2014 Posts: 4
Adding up cells if value equals

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
 Excel ex.xlsx (8.9 KB, 4 views)

Last edited by Kh1978; 07-15-2014 at 10:42 AM. Reason: added an excelfile
#2
07-15-2014, 06:32 AM
 SarahBear Windows 7 32bit Office 2010 32bit Novice Join Date: Jun 2014 Posts: 13

Can you attach a file with what your data looks like to begin with, and what you want it to look like in the end? I'm having too much trouble following your description to decide if I can help you with your question.
#3
07-15-2014, 09:54 AM
 WeDonNeedNoSteenkgRibbons Windows XP Office 2003 Novice Join Date: Jul 2014 Posts: 23

I agree with Sarah. At any rate, it's unclear whether column P has numeric values or strings; perhaps you'll need
=sumif(p\$4: p\$39, 1, c\$4:c\$39)
+sumif(p\$4: p\$39, 1, d\$4:d\$39)
+sumif(p\$4: p\$39, 1, e\$4:e\$39)
+sumif(p\$4: p\$39, 1, f\$4:f\$39)
+sumif(p\$4: p\$39, 1, g\$4:g\$39)
+sumif(p\$4: p\$39, 1, h\$4:h\$39)
+sumif(p\$4: p\$39, 1, i\$4:i\$39)
+sumif(p\$4: p\$39, 1, j\$4:j\$39)
+sumif(p\$4: p\$39, 1, k\$4:k\$39)
+sumif(p\$4: p\$39, 1, l\$4:l\$39)
+sumif(p\$4: p\$39, 1, m\$4:m\$39)
+sumif(p\$4: p\$39, 1, n\$4:n\$39)
+sumif(p\$4: p\$39, 1, o\$4: O\$39)

I'm unclear how to selectively suppress emoticons, but the left side of each above is : and P without a space and the last item on the right is : and O with no space
#4
07-15-2014, 10:44 AM
 Kh1978 Windows 7 32bit Office 2010 32bit Novice Join Date: May 2014 Posts: 4

Thanks
I have added an example Excel.
Thus there are several sheets as well I need to add the sum of all with type 1 for all sheets in the same excelfile.

Hope it is clear?!
/Kris
#5
07-15-2014, 11:52 AM
 WeDonNeedNoSteenkgRibbons Windows XP Office 2003 Novice Join Date: Jul 2014 Posts: 23

It is better to explain what you want to do more completely. Do you wish to sum the cells in
Code:
`A2:D6`
for type 1? Are A, B, C and D always the same as each other? For the data you included, is the desired result 1200? Does each sheet use columns A through E the same way?

Mod, I'm getting killed by emoticons. Is there a "quick disconnect" on one post or symbol?
#6
07-15-2014, 12:06 PM
 Kh1978 Windows 7 32bit Office 2010 32bit Novice Join Date: May 2014 Posts: 4
1200 +1200

I would like to sum all the kr for type 1 in the cells and sum up total for sheet Oct and Nov as in the example
Thus the total I am looking for is all kr for type 1 summed up for sheet oct and nov (1200 +1200)

Thanks
Kris
#7
07-15-2014, 12:48 PM
 gebobs Windows 7 64bit Office 2010 64bit Expert Join Date: Mar 2014 Location: Atlanta Posts: 832

There are probably better ways of doing this, but not knowing why you have your sheets set up the way they are, I suggest the most direct and easiest solution. For each row in each sheet, you could have an equation like

=IF(E2=1,SUM(A2: D2),0)

and then you would need to sum this column in each sheet and sum each of those results.

Alternatively, you could have one equation for each sheet like:

=sumif(E2:E6,1,A2:A6)+sumif(E2:E6,1,B2:B6)+sumif(E 2:E6,1,C2:C6)+sumif(E2:E6,1,D2: D6)

and then sum those results for each month.

Or even combine the equations for each sheet into a single equation though as the number of calculated cells decrease, the equation complexity increases.

Or you could redesign your sheets. Why not have all the data on a single sheet with the additional field for Month?

PS...the emoticons are annoying. First I have noticed it.

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post dirtboy Excel 3 06-20-2014 01:44 PM hotmud Word Tables 1 09-29-2013 06:12 PM zanat0s Excel 1 07-03-2012 04:27 AM geoff Excel 3 11-23-2011 01:20 AM danbenedek Excel 0 06-15-2010 12:40 AM

All times are GMT -7. The time now is 07:33 PM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top