Counting the frequency of a specific number on a specific day

    Hello; I need help counting how frequently a specific number occurs on a specific day. All formulas I have used either come up with an error or a incorrect result. I know I'm missing something but unsure of my error. I've attached a sample spreadsheet to visually see the question at hand.


    Any help would be greatly appreciated. Thanks in advance.
    Matthew

    Re: Counting the frequency of a specific number on a specific day


    Try:


    In I3:


    [COLOR="#0000FF"]=SUMPRODUCT(($A$3:$A$21=H$1)*($B$3:$F$21=H3))[/COLOR]


    copied down.


    Then you can copy I3:I11 to L3, O3 and R3, then copy to I15 and change the H$1 to H$13 and copy down, then copy I15:I23 to L15 and O15

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login