sum if help

Hello, As this is my first post I apologize if this has been answered previously, I am new here and was unable to find any similar posts. Let me catch you up on what is happening in the background as to why I need this function. I am running Windows 11 operating through Office365, however my...

Hello Gurus, Hope you had a nice weekend. I was trying to find a way on how to show the "Count of Indicator" but can't figured it out on Pivot. I was thinking that if it won't work on Pivot maybe IF formula or VBA would be helpful . Raw Account Country Data Score Indicator (value after...

Hello All, I am really new to this one.. and kinda got stuck. I am trying to add dynamic range and sum range to the SUMif Function.. but it's not working for me. when i break down the sum and the dynamic ranges its seems like they are working but not when i add them to the sumif. any ideas?

Hi, Probably a simple solution but here is the question: I want to concatenate text in cells that are in the " sum range" of a Sum If formula. I would like excel to take the names from Team #1 (column B) and put them in a single cell: glen, paul, mike Thought a sumIf might do it but...

Hello I have some raw data and I would like to sum my profit in the following group: 1. summing all count of negative value in one group 2 summing all count of $0.00 to $500.00 3 Summing all count $501.00 to $1000.00 4. Summing all count $1001.00 to $1500.00 5 summing all count above...

Hello geniuses, Imagine the table below is longer with more variables. Each color is a company. Number is dollars earned. There are three different businesses: A, B, and C. I'm trying to take the full sum of each company's book of business, but classify them by the more dominant business. So if...

Hi First time poster although long term reader! I'm learning Excel still and have learnt loads from these forums! Anyway....I'm struggling with a result I am trying to achieve. Basically I have a worksheet that collects all of my data and then I have separate worksheets displaying individual...

Hello, I have sheet 1 called Daily Leads October and sheet 2 called Daily Leads November_December In both sheets I have a list of products (10 different products) starting from cell B2 to B440 and I also have another column for total profit H2 to H440. In another sheet what i want to do is...