Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page I'm trying to get some fields to add up based on what appears in the field next to each of those I'm trying to get some fields to add up based on what appears in the field next to each of those
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 05-16-2016, 12:20 PM
DianeDennis DianeDennis is offline I'm trying to get some fields to add up based on what appears in the field next to each of those Mac OS X I'm trying to get some fields to add up based on what appears in the field next to each of those Office for Mac 2011
Novice
I'm trying to get some fields to add up based on what appears in the field next to each of those 		 
Join Date: Jul 2015
Posts: 4
DianeDennis is on a distinguished road
Default I'm trying to get some fields to add up based on what appears in the field next to each of those
Hi Folks!



Thank you for being here to help people like me!

I am on OS X 10.7.5 and using Excel for Mac 2011 version 14.5.1 (the online version).

I've attached a worksheet with a 'mini-example' of what I'm trying to accomplish with an explanation within the worksheet about which fields need to do what.

Is there a formula that'll do what I need?

Thank you so much!
Diane
Attached Files
File Type: xls ProjectTimeHelp.xls (35.5 KB, 12 views)
Reply With Quote
  #2  
Old 05-16-2016, 12:36 PM
xor xor is offline I'm trying to get some fields to add up based on what appears in the field next to each of those Windows 10 I'm trying to get some fields to add up based on what appears in the field next to each of those Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
You can use SUMIF.
Attached Files
File Type: xls ProjectTimeHelp_2.xls (28.5 KB, 10 views)
Reply With Quote
  #3  
Old 05-16-2016, 01:18 PM
DianeDennis DianeDennis is offline I'm trying to get some fields to add up based on what appears in the field next to each of those Mac OS X I'm trying to get some fields to add up based on what appears in the field next to each of those Office for Mac 2011
Novice
I'm trying to get some fields to add up based on what appears in the field next to each of those 		 
Join Date: Jul 2015
Posts: 4
DianeDennis is on a distinguished road
Default
lol that simple!

Thank you so much XOR!!

Have a great day!
Diane
Reply With Quote
  #4  
Old 05-16-2016, 01:23 PM
DianeDennis DianeDennis is offline I'm trying to get some fields to add up based on what appears in the field next to each of those Mac OS X I'm trying to get some fields to add up based on what appears in the field next to each of those Office for Mac 2011
Novice
I'm trying to get some fields to add up based on what appears in the field next to each of those 		 
Join Date: Jul 2015
Posts: 4
DianeDennis is on a distinguished road
Default
Wow XOR, that is very cool!

I had to study the formula (I have extremely limited knowledge with the formulas) and I figured it out and too cool.

Thank you again so much!!
Diane
Reply With Quote
Reply

Tags
formulas

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create an account number based on partials from 2 fields Sonataarctica2301 Excel 3 10-01-2014 01:42 AM
Creating new field in pivot table based off existing field laceymarie1987 Excel 0 06-26-2014 12:13 PM
I'm trying to get some fields to add up based on what appears in the field next to each of those Conditionally Email People Based on Values in Fields dawsonh2002 Mail Merge 2 12-12-2012 12:11 PM
dynamic charts based on mail merge fields jwajehee Mail Merge 0 10-05-2011 09:47 AM
I'm trying to get some fields to add up based on what appears in the field next to each of those field value based on time of day akraw Word 3 03-26-2011 08:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:00 PM.

Contact Us - Privacy Statement - Top

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