Get instant live Excel expert help with a COUNTIF Functions

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

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))

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.

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.

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.

I need help with countif excel, Ifthen calculations on a spreadsheet

I'd like to ask a question about a Countif formula

I want to use countif based on a cell reference, but ALSO count if the range contains the criteria in parts of the cells.

I need help with countif criteria. How do I get countif to count a single cell twice based on a criteria

using the countif function in excel between two dates, worked before but when expanding the data set does not work anymore gives #value error