#1




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) 
#2




Maybe like in the attached

#3




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; 03162019 at 07:17 AM. 
#4




I am not sure how you want to show it.
Please give examples in the workbook. 
#5




Please see attached.
Last edited by Alaska1; 03162019 at 07:10 AM. 
#6




Deleted again.

#7




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.

#8




Did you at all try the workbook I uploaded in #6?

#9




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. 
#10




Once more with mostly the same as in #6.

#11




#6 was one that I posted, not you.

#12




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. 
#13




Thank you for all your help

Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Formula require for MARKUP calculation  aysherryan  Excel  2  09182018 11:00 PM 
percentage calculation formula  yoyo4  Excel  10  11152017 11:44 AM 
Formula Calculation  medavidcook  Excel  2  03212015 03:47 AM 
Formula calculation  danbl  Excel  8  02232012 04:35 AM 
Excel 2010 formula rounds  arithmetic average calculation  YooNaa Kim  Excel  1  06072011 08:50 PM 