Here is what I am trying to do. I cannot get the HTML uploader to work....
I want to count the number of Alarm installs based on the criteria of a store number.
So I have 2 sheets. One with the store nubmers in Column A and Service Type in Column B. On my second sheet, I want to show the number of Alarms installed for each store.
The answer for store 5105 is 3 alarms, and for 5106 is 3 also like I show below. Then I want to show how many plumbing service calls for each store. So the criteria is the store number. I hope this makes sense.
For example.
Store # Service type
5105 Alarm
5105 Alarm
5105 Alarm
5106 Alarm
5106 Alarm
5106 Alarm
5108 Alarm
5102 Plumbing
5103 Plumbing
I cannot get various formulas (Countif, Match, Frequency, Etc) to work properly.
I am trying to arrive at a total number of matches of numbers in cell range B1:G1 with any numbers entered into the cell range of K1:P11 and have the total of matches display in cell H1. However I do not want to count duplicate numbers from the K1:P11 cells. (if the number 5 in posted in K1:P11 multiple times I only need it reported once in H1)
B1:G1 is the constant and the numbers will not change - K1:P11 cells will be populated by adding numbers until the all the numbers in B1:G1 is completed and match.
I came up with some formulas to count my data monthly. I have 12 tables with this kind of formula in it:
[Code] ....
Where B12 is the year and A213 is my month number. My first try on the "date filter" looked like that:
[Code] .........
And it wasn't working so I thought it was because the 31 wasn't a good idea for non-31-days-months but none of the formulas above are working.
(BTW, IDK why it's not working but I have data in my table for months 10, 11 and 12 and the only calculation tables that are calculating data are the ones for months 9 and 10. The results are the same in these two tables and are counting all my Table1[Data1] and [Data2] (the count is not monthly))
In my table I have a column called Series and Column called Games.
Now when a user makes an entry the do the following
Enter the Date of a game then a Series # (I wish I could make this auto increment because a series number can never be used more than once.)
then a game number starting with 1 and never going past 3.
Then Bet Team, Home or Away and Vs Team.
Now let it be know if the column called w/L = Win then that Series is over for ever and there will be no more games played.
If there W/L = Loss then I must create a new row for that SERIES with the next game number.
What I was hoping to do is
If I write in the following going in order Date ---4-11-09 Series # ---- 6 It should auto populate Game to the next game # Bet Team H/A Vs Team
I also want it to update my record
C3 is my series Wins D3 is my series Losses
I do not know how to populate that.
A Series Win = during a series game 1-3 where W/L = Win A Series Loss = a series 1-3 where there are no wins. A series does not count as a loss until you loose game #3.
I have list of states in column. Here I need to the group the cities and take the maximum counts for all those states. I have a huge data to do it. The countif() formula is taking too much of time. find the attachment.
In one cell i have a dropdown. Depending on what is in that dropdown, i want a table of data to be written. I'm not too hot with pivot tables but my understanding is that is predominantly to do with counts. This is more of a multiple vlookup i guess. I want to pull from a list of data (3), all the cases matching the dropdown (1) and deposit into a list (2). What is the best way of doing this? I don't want to use filters. See attached.
I'm struggling to work out a formula to do this even though it sounds simple.
I want to count cells in a particular row or column that contain any data, ideally without having to specify a range, so I just want to know that in column C contains x or row 5 contains y amount of data. So it would look at the entire rown or column and work out how many cells contain something and shows how many.
I'm sure it's been asked before but I can't figure out what words to use to find it in the search. Is there a formula that can count number of occurences of a streak. For example... I have data of the Washington Redskins kicker, kicking field goals over 40 yards for the past 10 years in Row 2. It is much longer then this, but this is a short example.
I'd like to count the number of times the kicker has made 3 field goals in a row. So, the first G...G...G would be 1 and so on. Any body know how to do this?
I am currently trying to count data in one cell separated by commas. The spreadsheet attached will make things look a lot clearer.
The "CURRENT" table is what I currently have and the "IDEAL" table is what I would like (but not hard-coded). Sheet 3 is where the meaningful data is. So for example, E4 has "CC-12" which is "Open" and "CC-11" which is "Closed". Therefore I would want there to be a "1" in cell F4 and G4 and a "0" in H4.
However I have survey data results and in one of the cells it has multiple values which are separated between ; and some are not separated at all e.g B&Q; The Range; Wicks The Garden Shop
Also there are spelling mistakes everywhere and variation of the word B&Q e.g b+q, B n Q
I need to add count up all of the B&Q, Wicks etc...
obviously if one wants to count all cells that contain data they can use COUNTA, but what if i have a range of cells that contain IF formulas and only want to count the cells that display data?
presumably you'd have to use some variation of NOT(""), but i can't seem to make it work.
So, in general I do have two columns F and G taken from the other xls.
Age is obviously difference between today and open date
Open date is open date.
I made a table like:
Age and due date.png
In this case, I have 3 rows where there is no open date extracted, therefore is no age. The counter stops on them and shows 529 in total instead of 532 or shows the age as far more than 365 days. How can I count the blank cells, but only in the range of the list I do have, not the all blanks I have from the beginning till the end of the column, so I could (for similar in this case) have 3 blanks cells counted?
Sometimes is also stuck in the middle of counting (when blanks are inside there) and the total number is even smaller. What function can I use to count these 3 (or less, more inn the future) as BLANK to have the total numbers realistic?
Employee Location John Florida John New York Jill Maine Jack Maryland
I would like to determine if an employee works across locations. My complete list has 550 names in it, this is just a subset of the data I am looking at. Above, John works in 2 locations, however Jill & Jack work at a single location. I am looking to differentiate cross locational versus single location employees.
I'm trying to count how many times an action happens between a time frame on a certain date.
This is how my data looks and comes to me (screen shot of a small portion of it - there are 22876 cells to count and it's very time consuming to manually):
data by rld2m2, on Flickr
There is no way to separate the date and time with the program the data comes from.
What I'd like to do is count what how many transactions take place between 10/1/2013 12:00:01 AM and 10/1/2013 3:00:00 AM (example time frame) from the above data.
I run an online golf tour and I need a little help with the coding of my handicap excel sheet. (For any golfers out there this is a custom handicap system, not the R&A version).
First I'll explain what I have, then my problem.
I have from left to right the following, Name, Scores, Worst Score, 2nd Worst Score, Average, Hcp. (There are other columns but are not important here)
The Scores columns record each round played, so at the moment we only have 10 columns with data as its the start of the season. I currently find the "Worst Scores" from the 10 columns, as they are all relevant at the moment. My problem will arise when I get over 12 columns of data. From that point on I need to find the "HIGHEST 10" from the "LAST 12" entries.
Easy you might say, BUT the last 12 rounds played could be spread over 100+ columns and every row could be different.
Example, Player 1 could have scores in column A to AB and then in AD to AE. Where as Player 2 could have scores in every alternate column.
I'm assuming I'll have to set up some form of count to count the cells that have data in them until I get to 12. Then extract the ones I dont need.
My question is, How do I find the last 12 column cells used in any row AND extract the highest 2 from those 12?
I have a spreadsheet that has Leads in column H for eg Advertisements and Presentation dates in column K
I need to set up a formula that will count the number of dates (Items) in column K that is applicable to the item in column H for eg Advertisements, Referrals etc . There can also be blank items in column K which can be ignored
my 1st spreadsheet has the following details:1)cars,(2) date sold,(3)month sold (4)new ownerunder the heading for cars there are 5 different models. On the 2nd spreadsheet i enter on a weekly basis the cars that were sold for the week under each category example:
ford 5 toyota 10 mercedes benz 3 and so on
i would like to know if these totals can be added up using a formula from excel in the 2 nd spreadsheet using the data from the 1st spreadsheet? there are 12 months in the month sold column and 5 different car models. i need to know that for feb there were 5 ford's sold although january had 10 showing as sold ? small example herewith
cars new owner selling price month sold ford Mr.Z 25000 jan merc Mr.X 49999 feb toyota Mr.A 34000 feb nissan Mrs.B 12000 jan ford Mrs.C 23000 feb merc Mr.A 34000 jan toyota Mrs.D 21000 feb
What I am trying to achieve using the example below:
ID Subject 1 Subject 2 Subject 3 1 Italian French German 2 Italian Art Physics 3 German French Italian 4 French Italian German
the result:
Italian French German 3 Italian Art Physics 1
As in the example, the combinations of Italian, French and German where counted, irrelevant of whether the subjects are in 2nd, 3rd or 4th column.
I tried to do this task by creating a pivot table but there are so many permutations and subjects that it would take me a long time to add the combinations.
want to be able to take a large quantity of data, sort all the like data together, and then quantify the number of each like data. I need the equations to do that.
I want it to count and fill in a range in column A until it sees a blank or notices the change in value in column B. In the example below i hope it shows what i need to do. i left the last group without numbers to show that is where it needs to start counting over again. i am basically wanting to count down 1st place 2nd place etc.
Here is the attached Excel file and the following is the desired output of the macro:
1.) List the data (Names) of the Columns D (Input), F (Analyze), and H (Output) in Sheet1 to Column A (Name of Person) in Sheet2. There should be no repetition of two names. 2.) Count the number of entries of each person in the Column D (Input) in Sheet1 appears per month (basis is the Input Date column E) and record into the corresponding month in Sheet2 under the Input Header. 3.) Add the total of the 12 months in the YTD column under the Input Header. 4.) Repeat steps #2-3 for the Column F (Analyze) and Column H (Output) of Sheet1 with the results recorded in their corresponding headers in Sheet2. 5.) Note: The data in Sheet1 is a running data and continually adds up as the current year goes by. If there is a way the macro could take that into account it would be much better.
I'm trying to find a way to take a data set and write an excel equation/s to find out how many times in that column of data a certain result (number or letter) occurs consecutively for more than 5 (hoping that this is also customizable) times. For example....
DATE USER A 1/1/2013 NO
[Code]....
Above are two columns, one with the date and another with the data I'd like to search through. So I'm hoping that I can write an equation/s that tells me how many times a certain value, in this case I'm looking for "No" occurs more than 5 times consecutively in the line of data. For example, for this particular data set, the final answer would be 2. There are only two instances where 5 or more cells with a "No" value follow each other.
Using COUNTIF/COUNTIFS how to counting data with 3 mode ;
name property checking
[Code]....
I want to count with criteria based on adjacent value "name" column related with "checking" column
1) counting data "name" with "yes" criteria? 2) counting data "name" with "yes" & "no" criteria? 3) counting data "name" with blank "" criteria? 4) counting data "property" with criteria contains "name" and "yes" criteria