# 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

## Files

• 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!

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

Wow; I'm stoked. Thanks. It works perfectly

## Participate now!

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