Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-14-2019, 06:18 PM
Alaska1 Alaska1 is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: Nov 2011
Posts: 80
Alaska1 is on a distinguished road
Default calculation formula

I am trying to create a formula that would pick up the event and then calculate the total number for each contact.

For example: Sally Potato registered for Webcast total of 4 times totaling all the columns for webcast attended etc.. (see attached)
Attached Files
File Type: xlsx Book1.xlsx (8.8 KB, 6 views)
Reply With Quote
  #2  
Old 03-15-2019, 01:39 AM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 987
xor is just really nicexor is just really nicexor is just really nicexor is just really nicexor is just really nice
Default

Maybe like in the attached
Attached Files
File Type: xlsx Contacts.xlsx (11.0 KB, 4 views)
Reply With Quote
  #3  
Old 03-15-2019, 07:39 PM
Alaska1 Alaska1 is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: Nov 2011
Posts: 80
Alaska1 is on a distinguished road
Default

Thank you. the formula worked.

I have another worksheet. In this one I want to total the up the number in column A for each different activity column. I will be adding columns so what the formula to pick up as I add. Do I use an array formula? See Attached worksheet.

Last edited by Alaska1; 03-16-2019 at 07:17 AM.
Reply With Quote
  #4  
Old 03-15-2019, 09:47 PM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 987
xor is just really nicexor is just really nicexor is just really nicexor is just really nicexor is just really nice
Default

I am not sure how you want to show it.
Please give examples in the workbook.
Reply With Quote
  #5  
Old 03-16-2019, 03:18 AM
Alaska1 Alaska1 is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: Nov 2011
Posts: 80
Alaska1 is on a distinguished road
Default

Please see attached.

Last edited by Alaska1; 03-16-2019 at 07:10 AM.
Reply With Quote
  #6  
Old 03-16-2019, 06:21 AM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 987
xor is just really nicexor is just really nicexor is just really nicexor is just really nicexor is just really nice
Default

Deleted again.
Reply With Quote
  #7  
Old 03-16-2019, 07:16 AM
Alaska1 Alaska1 is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: Nov 2011
Posts: 80
Alaska1 is on a distinguished road
Default

I posted the wrong document. I can use a sum formula but I am going to continue to add columns. That mean?s I have to change the formula every time. Please overwrite the other document. I uploaded a new document.
Attached Files
File Type: xlsx book4.xlsx (10.1 KB, 1 views)
Reply With Quote
  #8  
Old 03-16-2019, 07:29 AM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 987
xor is just really nicexor is just really nicexor is just really nicexor is just really nicexor is just really nice
Default

Did you at all try the workbook I uploaded in #6?
Reply With Quote
  #9  
Old 03-16-2019, 07:48 AM
Alaska1 Alaska1 is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: Nov 2011
Posts: 80
Alaska1 is on a distinguished road
Default

Hi

No that was the wrong document I posted in #6. I posted a new workbook. May I ask that you removed the document from #6. I posted a new document in 7.
Reply With Quote
  #10  
Old 03-16-2019, 08:01 AM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 987
xor is just really nicexor is just really nicexor is just really nicexor is just really nicexor is just really nice
Default

Once more with mostly the same as in #6.
Attached Files
File Type: xlsx book4_2.xlsx (13.1 KB, 1 views)
Reply With Quote
  #11  
Old 03-16-2019, 08:03 AM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 987
xor is just really nicexor is just really nicexor is just really nicexor is just really nicexor is just really nice
Default

#6 was one that I posted, not you.
Reply With Quote
  #12  
Old 03-16-2019, 08:12 AM
Alaska1 Alaska1 is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: Nov 2011
Posts: 80
Alaska1 is on a distinguished road
Default

Okay thanks I will try this one. You posted #6 but it was my document that you were responding too. I did not want to post the document with that document name that is why I asked to remove your post. I removed mine.

I will take a look at the new one.

Thank you for all your help.
Reply With Quote
  #13  
Old 03-16-2019, 08:39 AM
Alaska1 Alaska1 is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: Nov 2011
Posts: 80
Alaska1 is on a distinguished road
Default

Thank you for all your help
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula require for MARKUP calculation aysherryan Excel 2 09-18-2018 11:00 PM
percentage calculation formula yoyo4 Excel 10 11-15-2017 11:44 AM
Formula Calculation medavidcook Excel 2 03-21-2015 03:47 AM
Formula calculation danbl Excel 8 02-23-2012 04:35 AM
Excel 2010 formula rounds - arithmetic average calculation YooNaa Kim Excel 1 06-07-2011 08:50 PM


All times are GMT -7. The time now is 05:23 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft