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

Popular posts from this blog

OpenCV OpenCL: Convert Mat to Bitmap in JNI Layer for Android -

android - org.xmlpull.v1.XmlPullParserException: expected: START_TAG {http://schemas.xmlsoap.org/soap/envelope/}Envelope -

python - How to remove the Xframe Options header in django? -