Search:

Type: Posts; User: Josh08; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: Counting a Time Range with COUNTIFS or SUMIFS

    I believe that adding the "=" has done the trick. Not so much for the formula that I had for the 3rd shift but instead I did what you suggested. Total - (1st shift _ 2nd shift). Now the totals are...
  2. Re: Counting a Time Range with COUNTIFS or SUMIFS

    What the totals should be:

    1st Shift = 273
    2nd Shift = 85
    3rd Shift = 12
    Total = 370
  3. Re: Counting a Time Range with COUNTIFS or SUMIFS

    I think I'm almost there. I was able to convert the values to numbers successfully. I now have a count of 370 numeric Time values in Column B of my spreadsheet.

    I'm trying to capture Action...
  4. Re: Counting a Time Range with COUNTIFS or SUMIFS

    I still didn't yield the appropriate count. Perhaps it has something to do with them not being numbers? See response below 70 are numbers, 380 aren't.
  5. Re: Counting a Time Range with COUNTIFS or SUMIFS

    70 = True
    380 = False
  6. Counting a Time Range with COUNTIFS or SUMIFS

    Good Morning

    I have an issue. I've been trying to create a formula to count the number of instances a particular time range appears in a column on a spreadsheet.

    Column C contains manually...
Results 1 to 6 of 6