Formula help

Kiwi-123 used Ask the Experts™
Please can you help me amend the formula on sheet 2 (D7:D8)

The formula counts the occurence on sheet 1, but I wish to make the date range it searches for to be:- sheet 2 (D3:D4)
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mechanical Engineer
Most Valuable Expert 2013
Top Expert 2013
For the Number in cell D7, you might try:

And for the Count of Yes in cell D8, you might try:

Both of these formulas are looking at visible rows only

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial