User Profile
Helen15
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Summing 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.997Views0likes3CommentsSumIfs 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.5KViews0likes6CommentsHelp 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.1KViews0likes10Commentscalculation creating unique email address
Can anyone help me with a formula please. I have about 8 columns of email address for an individual (some are blank and some are the same email) and want to create a formula in the last column to create a unique list of those email address and leave the blank ones out for that individual. I have about 5,000 rows and so need a formulae to do this. Can anyone help please. Many thanks4KViews0likes17Comments
Groups
Recent Blog Articles
No content to show