Countif and suming a time

  • Thread starter Thread starter Pinehurst
  • Start date Start date
P

Pinehurst

I have a spreadsheet with a couple of couluns that contain decriptive text
of tasks driven by drop downs, and a column that contains time spenyt on a
task.

I use countif to find out how many times a specific task was done, but I now
must also work out how much time is spent doing that task.
Any help please
 
I use sumif with countif
=COUNT(F737:F949)
=SUMIF(F737:F949, ">0", E737:E949) this tests to see if a value is greater
then zero, remember you need doubble quotes arount your test in this function.
Remember that you use your test range, then if statment and then your sum
range.
=SUMIF(TEST REANGE, TEST, SUM RANGE)
 
Back
Top