C ccarruth Member Mar 1, 2018 #1 Example worksheet attached. Standard countif formula is returning 0. Don't know why. a) task is to count number of cells meeting or exceeding reference cell b) second task is to add up values of the cells in a) So simple...can't see it. Attachments Excel countif problem.xlsx 8.8 KB · Views: 2
Example worksheet attached. Standard countif formula is returning 0. Don't know why. a) task is to count number of cells meeting or exceeding reference cell b) second task is to add up values of the cells in a) So simple...can't see it.
N NARAYANK991 Excel Ninja Mar 1, 2018 #2 Hi , See the attached file for the correct way to use a parameter in a SUMIF function. Narayan Attachments Example 1.xlsx 8.8 KB · Views: 4