Results 1 to 3 of 3

Thread: FREQUENCY---how to use it

  1. #1

    FREQUENCY---how to use it

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am new to Excel. I am trying to create a formula in a payroll worksheet for determining how often employees work 0-19 hours, 20-29 hours, 30-40 hours and 40+ hours.
    I have the Bin number set up as O, 20, 30 and 40. Let's say they are in a range from F7 to F10.

    My hours for each employee are in a row from B5 to B18.

    How do I make the formula?

  2. #2
    Acolyte Kevin@Radstock's Avatar
    Join Date
    Oct 2012
    Excel Version
    Hi Steph

    No need for the zero in cell F7

    Select cells G8:G11: =FREQUENCY(B5:B18,F8:F10) To commit CTRL + SHIFT + ENTER


  3. #3
    Thank you, Kevin!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts