User Profile
Helen15
Copper Contributor
Joined Nov 20, 2020
User Widgets
Recent Discussions
Re: SumIfs and Sum Products
Hi Khaled I'm sorry to come back to you but I need some further help with summing up a code from multiple sheets in the same workbook. I want to sum up several tabs into a main consolidated tab for certain codes and my formula that I thought would work, doesn't. I have attached a file to my newest post for help but can't seem to attach it here. Are you able to take a look? sorry i just know that you are very good at formulas. Many thanks1.3KViews0likes1CommentSumming up a code from multiple sheets in the same workbook
Can someone please help me. I want to sum up several tabs into a main consolidated tab for certain codes and my formula that I thought would work, doesn't. I have attached a file to help explain what I want. Any help much appreciated.1.1KViews0likes3CommentsSumIfs and Sum Products
I need help on a report that deals with sum ifs or sum products BUT I'm struggling to get it working. So if someone could take a look and PLEASE HELP me it would be very much appreciated. All the comments are on the tab called summary, the other tabs will just be data tabs that I will need to add up and report the figures in the summary tab. If its not clear but ask me questions so you understand what I need. Thank you for your time.1.8KViews0likes6CommentsHelp with a formula to miss a cell that is zero
I am having problems with this formula, I need it to only pick up the code that has a value in cell B. But my formula in column F doesn't work as it duplicates the the cell underneath (as highlighted in red). Does anyone have any suggestions ? many thanksSolved1.3KViews0likes6CommentsHow do I create an formula containing IFs, OR ANDs and lists?
Can anyone simplify this formula in the attached excel. This is just an example but the lists are very long and I wanted to see if there was a better way of doing this. Many thanks in advance it is MUCH appreciated.Solved2.3KViews0likes10CommentsRe: calculation creating unique email address
SergeiBaklan Hi, just got back into looking at this and I really don't understand why the exact same formula works on your excel and not mine. Can you please open the test file below and does the formula show the unique email addresses on your excel ? as mine does not, its doesn't recognize that they are the same email address and then just adds all of the email addresses together. Thank you so much for your help and i'm completely stuck !3.9KViews0likes1CommentRe: calculation creating unique email address
I'm even more confused, when I open up your file it does only show unique email address but at the top of excel it says " Protected view: Be careful - files from the internet can contain viruses. Unless you need to edit, it's safer to stay in protected view" then there is a button to press which says "Enable Editing". As i need to enable editing i click on the button and then the formula doesn't work as they go back to a list and not unique email address. Is there some sort of excel option that i need to tick to let this formula work? Many thanks in advance.4KViews0likes3CommentsRe: calculation creating unique email address
just google and i found this: "Note: The UNIQUE function is part of the new Excel Dynamic Arrays family and at the time of writing, Dynamic Arrays are only available in Office 365 and are currently in beta on the Insiders channel. Excel 2019 will not have the Dynamic Array functions." really is not English to me.4KViews0likes0Comments
Recent Blog Articles
No content to show