## Countif formula across multiple sheets

I am setting up a workbook for tracking some video game elements for a friend. It’s set up with a couple cover sheets that pull data from 100 …

Excel 2003 Help. Free Excel help for formulas, functions, macros, spreadsheets and VBA.

I am setting up a workbook for tracking some video game elements for a friend. It’s set up with a couple cover sheets that pull data from 100 …

hi, the value of a number i am pasting is 10 decimals long (ex: 55.4297804839) but i got the cell to show 1 decimal (55.4) how can i change the value of …

I have a spreadsheet with hundreds of cells and formulas in a high percentage of them. Rather than transcribe each cell’s formula, is there a way …

I have a spreadsheet with hundreds of cells and formulas in a high percentage of them. Rather than transcribe each cell’s formula, is there a way …

I have a spreadsheet with hundreds of cells and formulas in a high percentage of them. Rather than transcribe each cell’s formula, is there a way …

Hi, I am looking for some support regarding the below issue. A B C D Lead Time Example Wk 36 2019 Wk 50 2020 19 If (CD + Lead Time is less …

I have a spreadsheet that needs to update the current date in (for instance) Column B1 if anything has been selected from a dropdown menu in Column C1. …

I have a spread sheet with data. Column A is date stamped for a month. Columns c-I have readings. What I need is a formula to capture the individual day in …

Hey guys, I’m looking to my Google sheet has varies columns with values inserted in the rows (62 rows). I want to insert a few rows to represent what …

I need to find out how to place a bottom border ONLY on each row of a table that is 20 columns by 1000 rows in size. How can I get this with less than 5 clicks …

I am a user of Excel for Mac, version 16.16.5. I am sorry that I have no idea of the required code in total, but I am familiar with recording macros, …

Hi, I have linked two workbooks and have runa frmula but when I try to copy the formula don is just stays specific to initial cell I put in the …

To whom it may concern, I write a VBA code for Auto sorting the columns. I have problems with this. I define multiuser for it with their own passwords. so, I …

i have bunch of text on sheet. i must find word that ends with ‘owa’, ‘ow’ and ‘ew’. and copy that finded words to another …

Dear Excel Geek, I have a program that exports a tab-separated values into the clipboard. When I paste directly into excel (for example at A1), the …

Suggest a formula for the below problem: Consider Sheet 2 of the attached file: As you can see two cells i.e. H17 & I17 are highlighted. When two …

Hi there, I am using excel and need some assistance. I have 2 columns of data. The first column is a list of countries and the second column is a list of …

Hey there! I’m new here and having trouble setting up a formula that will return a value based on a tiered billing. Example: A1 …

How can I make this VBA loop througt all sheetstabs Option Explicit Sub TEST() Dim a As Long, arr As Variant, fnd As Range, cpy As …

I need an Excell formula to select names from a list of names. By: John

Hi,I have entered entry and leaving dates from Country for last 3 years, and have found the number of days in between. I want this conditional, example in …

Hi , Thanks in advance for your time. I am trying to figure out a formula to help me return data fields that match information in columns. …

I have created a custom list for a slicer with the questions in the order I want listed. When I save and open on my computer it remains, but if I save and …

How can I make it so that when I input a number into Worksheet 1, cell B1(#household members), B2 updates with the corresponding number …

Hello fellows, hope any of you can help. To make long story short I have a very complicated formula where I need to enter 2 values for excel to return …

I have a table. In the 1st column there are voltage levels i.e. 400,300,200,100 V etc. In the 2nd column, the short description of items related to voltages in …

I wanted to create a formula that can detect if the value’s decimal in the cell is over .60 and if true then to subtract 0.4. So I have 38922.64 …

Hello: I am trying to create a formula that will search two columns of data. Each column is on a separate sheet within the same workbook. If …

A B answer 100 300 100 100 100 100 300 900 500 500 …

Can anybody suggest a way to check whether any three consecutive cells in a column are equal? Anywhere in the column, but there must be three identical values …

I have a press sheet that I can get 7 up of a 12 x 6 object. I have 6 different graphics – but they are all the 12 x 6 size – just different …

I have an issue where all macros I create generate an error message in that it can’t find the corresponding workbook where I am copying text from. My work …

Hi hope you can help Is there a formula where I can get column D to equal column C, if column A is equal or < 0.01 or > 0.01 A …

Dear Spreadsheet warriors i’m trying to create a project number generator using excel by choosing from a selection as per the spreadsheet provided …

Hi, we want to make Project tracking table that will autofill cells with color based on the data inputed into a table. The table is simple, its 2 columns and …

I have two sheets in excel, firstly I am wanting to find out which names are not in sheet 1 but are included in sheet two. Sheet 1 will eventually be …

Hey everyopne I want to make an excel sheet for a number of people who pay for a service all togther. I want to be able to type the amount of payment made. …

I have an excel spreadsheet that takes information from a main sheet and uses formulas to break it down into smaller sheets. I also need it to format the …

I have tried searching and cannot find what I need. I currently have 5 worksheets within my workbook. They are all the same worksheet just named …

I have set up a Conversion sheet(mac excel 2007) and would like the cell selection to go to the “RESULTS” column once the user has entered data in …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.