 # Get instant live Excel expert help with a COUNTIF Functions “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

I have a spreadsheet with lots of values in it, and this IF function: =If(countif(3:3,"SR")>1,7.5,(if(countif(3:3,"SR")>0,4,0)) ) This works fine, however I want to add up a number of these for subsequent rows e.g. 3:33, i assume its something like =sum(3:33,If(countif(3:3,"SR")>1,7.5,(if(countif(3:3,"SR")>0,4,0)) ) But I am not sure
Solved by A. Q. in 25 mins
My dependent data validation formula works only for the first row. the formula I'm using is: =OFFSET(Heading Cell, MATCH(cell, picklist range,0),0, COUNTIF(picklist range, cell))
Solved by O. L. in 23 mins
I am comparing two columns in excel for matches and differences. The formula I am using is =IF(COUNTIF(\$B:\$B,\$A:\$A)=0, "a","z"). The problem is that I can visually see that some of the data is the same but yet the formula is returning a 'z'. I have checked the formatting of the cells as well as copying and pasting the value only over to a new workbook but the formula still returns a z. In my example I copied the contents in A1 to B3 and but the formula still returned a z value. I am using Excel 2013.
Solved by F. S. in 19 mins
I have a table of data showing how much each individual produced every day of the year. I then summed the total for each individual for the entire year. I would like to narrow down which individuals had a total below average, shown on a different table. I am only able to countif individuals were below average, but I want to show specifically which ones were below average, instead of going manually and picking which ones were below and which ones weren't (it is a lot of data). I have already used conditional formatting to help me visualize which ones were above average (shown in green cells) and which ones were below average (red), but I would still have to pick them individually if I were to represent in a new table specifically which ones were below average. Any help on which equation can perform this action? It would be something like show which individuals were below average, and the result would be about 50 data points in 50 different cells.
Solved by S. H. in 25 mins
I am using Countif to check one column of words against another and seeing if they partially match and it should return a 1 or a 0 each row. The problem is that the cells are not just text, they are formulas, and it seems like countif does not work when the cells contain formulas because when I run the COUNTIF I get all 0s, even though I can see some words are the same. How can I fix this? Or is there another formula that works better.
Solved by I. J. in 22 mins
I need help with countif excel, Ifthen calculations on a spreadsheet
Solved by O. J. in 22 mins