Excel Formula To Count Sum of the Cells -
i have sheet in have hours devoted particular task summed @ end. want count number of cell in sum of hours specific number(e.g. 9. unable apply countif function exact results.
unable attach screenshot, overview this
task1 task2 task3 task4 total
and want calculate how many time particular hours repeated in "total" in next preceding sheet.
=countif(c:c,9)
should work column c
contains sum of hours
Comments
Post a Comment