#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; 03-16-2019 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; 03-16-2019 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
|
|
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 |