# formula help

1. ### Count no'of empty cells with no color fill

Hi all, I am looking for a formula which will count the no of blank cells in a column having no color fill. I have values in both filled and unfilled cells. i want to get the count of unfilled cells if there is no value in it.
2. ### Need help with a formula

Hi everyone! I have been asked to lead a presentation for my company. I have a shortened list of some of our sales staff and a longer list with all staff. Is there a way to transpose a list of quarterly performance from the shorter list onto the longer one whilst keep any gaps? I am fully a...
3. ### Formula help required

Hi, I am a teacher and I have been given a list of students who's grades I need to have a closer look at in excel. I have a curated list of students in one column and the raw listing of the students in the next column with the associated grades after that. I want to remove all the students from...
4. ### SUMIF/SUMIFS Help

Hello I am trying to track my energy usage and have a spreadsheet with two sheets ABCDEFG1No.Period FromPeriod toElectricGasVATTotal2101-Mar-2229-Mar-22 ABCDEFGHIJ1No.Period fromPeriod toFuel / StandingTypePrevious ReadingLatest ReadingUnits UsedKWH Rate or Standing Charge Daily Rate...
5. ### Sumproduct formula question (no VBA, please)

Hello excel experts, I have the following formula: =SUMPRODUCT(SUBTOTAL(103,OFFSET(\$F\$26,ROW(\$F\$26:\$F\$999999)-ROW(\$F\$26),0)),(\$A\$26:\$A\$999999=\$A21)*(\$B\$26:\$B\$999999=\$B\$7)) The issue that I have run into is that each time I update my pivot table that uses this formula I run out of resources. I...
6. ### How to reference text in a cell in a formula in another cell.

I've been given a work assignment where I need to fill out an individual tab per sales account. Some of the accounts are locations of a larger parent company. The original template given to me by my organization requires entering data in a single column (C) answering questions/data points...
7. ### Looking to find the cell returning the first number greater than 1 and return the column header for that cell

I've got my column headers as dates Column C:N and my rows 2-3 contain the numbers. I'd like to find the cell in row 2 that first reached a number >=1 and return the date in column header. I'd like to have Column T return the column header for the cell that first meets my criteria. My formula...
8. ### Work Project - Formula help needed!

Hi Guys :) I am a novice Excel user who is looking to automate my workload to save me time. I am currently working on a financial project for my business and I have attached a screenshot to show what I am talking about. I have my data which gets pulled automatically on the left and then I...
9. ### Formula to return the position of the last occurent character

The title can be a bit hard to understand. English isnt my native language, so i am sorry. What i meant is this: I have a Cell with a value of, lets say, "1,2,3". Now i want the position of the last comma. In this case it would be the Position 4. How can i search for it with a formula?
10. ### Issue with formula not reading from a specific cell

Hi all, I use a spreadsheet as a tracking doc to keep track of our process from project upload through client approval. The way the doc is set up is Column A (Name) has the name of task. Column B (OMIT) is where we log if a task has been omitted. Column D (Code) host the code I need help...
11. ### Formula Help: Possible Nested IF/AND issue

I'm having trouble coming up with a formula that will check for certain conditioners in a specific order. Any help is appreciated. If D144 is blank and E144 is not ‘Specific Text A or Specific Text B’, return E144. If D144 is Blank and E144 contains ‘Specific Text A’ return ‘Specific Text X’...
12. ### Need Help Converting this Formula to Use CONCATENATE Instead of &

I am stuck trying to convert this dynamic formula to use the CONCATENATE function instead of the &s. I am using an Excel add-in that does not accept "&" in formulas. I have tried several times to do this myself but cannot figure out what I am doing wrong. It doesn't seem to play nicely with the...
13. ### Applying a set value to columns until the value is reached

Hi and thanks for helping. I'd like to apply a known deposit amount (B1) to a set of projected income for the year (B3 - M3) If the monthly income is less than the deposit a "No Invoice" is returned under the related month (example B4 & C4) If the deposit is applied, but there is a remainder...
14. ### Formaula Assistance

I own a small business and I'm having trouble with employees adding incorrectly and I'm wanting to create a spreadsheet that will do the math for them. As a part of my business I sell lottery scratch off tickets. Each ticket is numbered and we count them down at the end of the day to determine...
15. ### If index match

Hi all I could really do with some help as I can't get this formula right. I've been trying to use IF INDEX MATCH. IF A2 contains 2016 INDEX data from Column C MATCH H5 postcode with X5 postcode I basically have numbers in column C that I want listed in a new table, but only if cell A2...
16. ### Help with SUM formula based on data in separate table

Could I get some assistance on a formula that I need in cell B11 below, where I'm looking to sum the total in column B for all of the units that are categorized as "old" (i.e. what's in cell A11) based on the table in F1:H7. Excel 2013 64 bitABCDEFGH1Location1Location2Location1Location22Unit...
17. ### Help!!! I have no clue where to start.

I am stumped! I am trying to figure out a formula and it is jut not working. I am working with SKU's and UPC's. Where I work I am dealing with product that has either a SKU or a UPC on it, and I am currently in the process of having to verify where product is in the warehouse. What I am needing...
18. ### Custom Data Validation Help

Hi, I am trying to create a custom data validation and I need some help with the formula syntax. In my spreadsheet Column B has a drop down that says "Refund" and "Charge". I want to create the custom data validation in Column D to limit the number of characters in the cell so that any line...
19. ### PowerPivot: Add one product to another

We are getting rid of some old products, and directing the demand for the old product to a new product. I am trying to setup a table which shows the change in demand for the new product. Here are some very simple tables which lays out what I am working with. I have a table called SKU_Mapping...
20. ### Frustrating Formula, Need Help!

Hey there, Basically I have a tedious routine process that I think can be simplified by having excel do it for me in a formula. Only issue is that I'm not too great with these. Any help would be greatly appreciated!! The process is as follows: I receive a spreadsheet everyday with many...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back