“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

countif formula for cells A1,A2 and A4 if greater then 0

Solved by A. H. in 20 mins

I need a variable cell reference. I am using the countif function and I need the starting and ending arguments to vary.
For example:
=countif(x1y1:x2y2, "str")

Solved by V. Q. in 25 mins

Looking to get every D to add 1 and every H to add 0.5.
=SUMPRODUCT(COUNTIF(INDIRECT("'"&Data!$C$2:$C$13&"'!B4:AG4"),{"D","H"},{1;0.5}))

Solved by I. F. in 27 mins

I'm trying to Countif certain characters in a string - e.g:
"Trump" in a range of 100 headlines... but rather than state the string, I want to match it to a criteria in a cell...
What I have at the moment:
=COUNTIF(Table1[Linked Headline],"*Trump*")
What I want:
=COUNTIF(Table1[Linked Headline],"*B2*")
But the second returns nothing, even though B2 contains 'Trump'

Solved by M. L. in 15 mins

having issues with countif forumla looking up values in a text string seperated by commas, whereby values can be similiar i.e S1 and 1, countif brings in values for both when not desired.

Solved by F. H. in 26 mins

I have used a countif formula =COUNTIFS('2017 Inspections'!M4:M486,"22/01/2018",'2017 Inspections'!N4:N486,"=Lynda Hall",'2017 Inspections'!O4:O486,"Confirmed") to create a tally of inspections on a certain date, by a certain inspector and of a certain status. I now need to create a job listr of what properties the inspector will visit on these days. To do this I need to search for the same result as the countif but return the address, postcode and owner name which are in the first 3 columns of each row.

Solved by T. S. in 15 mins

I have a range of cells, (A1:A100); for each cell in that range that meets a certain criteria (=1) I want to see if the value in Column F of THE SAME ROW meets a certain criteria (=SL); if both conditions are met, then add 1 to a counter cell. I would like to use the COUNTIF function.
PLEASE HELP

Solved by D. U. in 16 mins

For a CountIf function, can I select a range of cells for the criteria portion of the formula rather than just one cell?

Solved by S. C. in 15 mins

This is my formula: =IF(COUNTIF($J$1:$J$818;B11);(K:K);(I11*0.68))
what i want is, if it is true, to get the value adjacent to the cell with the value but it just give me the value of K2

Solved by B. J. in 26 mins

i had been in a session earlier regarding this matter, which went very bad and he told that it can not be done using excel countif function. i want some help with countif function please dont take this question if you cant solve it and i need to solve it by countif only.

Solved by G. W. in 21 mins