Multiple Selections Drop Down List (used a VBA code) & CountIfs
I used a VBA code to allow me to select multiple items from a drop-down list in a particular column. I have two other columns with other drop-down lists but not allowing for multiple selections. I'm using COUNTIFS to count for certain parameters among the three columns in 3 x 2 columns for each parameter. When I use COUNTIFS, excel doesn't count the parameters in the multiple selection drop-down list. It'll count only if I select one item but once I select more than one, it doesn't count any of the parameters. How can I get excel to count what I want it to count? Thanks.
COUNTIF not working
I have a list of 25 numbers in one column (range). There is one "0" in the list. In another cell when I use =COUNTIF(range, "=0"), I get a value of "1" as you would expect. HOWEVER, when I use =COUNTIF(range, "<1"), I get an output value of "0" rather than "1" which is inaccurate. This is not the only problem. For example, when I input =COUNTIFS(range, ">1", range, "<=3" I am also not getting the expected value. I have already worked with Microsoft to update Excel and when that didn't work, we reset Excel, but that did not help. From other forums I learned that I needed to make sure the cells are formatted as "General" or "Number" rather than "Text," which I have also done, but to no avail. Please advise. Thank you!Totaling using two sets of data
I am trying to count and get the total of 2 sets of data: one set includes dates, the other includes words. The dates all include month, day, and years, but the data I would like to use in my results would just consist of the years. I'm working with semi trailer repairs, so the formula I would like to use should be saying "count all issues only if year"...like "count all tire repairs only if 2016". I have been googling and looking around, but all I can find on the subject is to get a result of true or false, but I want a number as my result. so far, I have this: =COUNTIF(issues,"axles")+COUNTIFS(dates,">="&DATE(2016,1,1),dates,"<="&DATE(2016,12,31) I named one column "issues" and another column "dates." ("axles" is one of the issues I'm trying to total.) I know this formula is valid, but it adds the totals of the "issues" column and the "dates" column separately instead of taking both into account in the total, if that makes sense. Hopefully someone can help!
COUNTIF help
Hi all, I'm running a COUNT IF in a table, receiving data input from Forms. The info is and will continue to come in for a long time yet. The formula I'm using is =COUNTIF($D$2:D2,D2) As i progress to row 15, it reads =COUNTIF($D$2:D15,D15) This is so that I have a progressive number generator so that I can individualize every entry. This serves to feed the table information into a tidier front end. My problem is that with each new entry, it interprets the count range to be (top of table:bottom of table) I'd like to be able to have a progressive count function, that takes the row value as being the same as where the formula exists. In the above, col B has the formula, D is the code being used, E is a combination of, allowing for individual row lookup on the front end. As entry 110 comes in to row 110, it will change the formula in 109 from =COUNTIF($D$2:D109,D109) to =COUNTIF($D$2:D110,D109). That creates headaches where the value of D repeats, as it creates a count of the entire table, I want a count from table top, to current row value only. Ideally I want this to all happen automatically without having to refresh the formulas. It also needs to work in Excel online with its reduced functions (no Macros) I hope all of that makes sense - any help appreciated.
COUNTIF Formula Help - Embed another formula
Hi! I have been trying to figure out a formula within a formula, and cannot get it right. I have two sheets, Sheet1 and Sheet 2. On Sheet 1 I have a column of names. Some of the names are duplicated many times. On Sheet2, I have a name column, and a number column. I want to count how many times each name was duplicated on Sheet1. The forumla I have is =COUNTIF(Sheet1!$A$2:$A$20,"John") and it works. However, I have to manually type in the name, example "John" from the name column. Due to how many names I have, I'd like the formula to have another formula embedded that will pull the name from the column to the left, and then lookup and count on sheet1. I hope this makes sense. Thanks for anyone's help!!!
