U
ummone
I need to create a count if cola and colb meet a certain criteria. Example:
A B
6-Jul dog
13-Jul dog
6-Jul cat
6-Jul dog
13-Jul dog
13-Jul dog
13-Jul cat
13-Jul dog
The count would be 2 as I am looking for dogs on July 6. The hiccup is the
date. I need it to calculate the WEEKNUM as a separate entity for each
weekending. The output should look something like this.
W/E count dog count cat
6-Jul 2 1
13-Jul 4 1
I currently have this:
=SUMPRODUCT((A2:A5001=39970)*(E2:E5001="dog"))
But I have to go in and generate a new formula for each weekending, and I
need to avoid that.
Many thanks for any help.
Regards
A B
6-Jul dog
13-Jul dog
6-Jul cat
6-Jul dog
13-Jul dog
13-Jul dog
13-Jul cat
13-Jul dog
The count would be 2 as I am looking for dogs on July 6. The hiccup is the
date. I need it to calculate the WEEKNUM as a separate entity for each
weekending. The output should look something like this.
W/E count dog count cat
6-Jul 2 1
13-Jul 4 1
I currently have this:
=SUMPRODUCT((A2:A5001=39970)*(E2:E5001="dog"))
But I have to go in and generate a new formula for each weekending, and I
need to avoid that.
Many thanks for any help.
Regards