Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 07-15-2014, 09:54 AM
WeDonNeedNoSteenkgRibbons's Avatar
WeDonNeedNoSteenkgRibbons WeDonNeedNoSteenkgRibbons is offline Adding up cells if value equals Windows XP Adding up cells if value equals Office 2003
Novice
 
Join Date: Jul 2014
Posts: 23
WeDonNeedNoSteenkgRibbons is on a distinguished road
Default

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
Reply With Quote
 



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
Adding up cells if value equals how to keep text format when adding new cells? hotmud Word Tables 1 09-29-2013 06:12 PM
Adding up cells if value equals How-TO format cells (FILL) by comparing cells zanat0s Excel 1 07-03-2012 04:27 AM
Adding up cells if value equals 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:13 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft