Forum Discussion
Amyra Baig
Sep 26, 2018Copper Contributor
HELP excel homework question
HI i need help with a question on my homework that i have been stuck on for two hours please help i'm actually about to cry because I havent been able to figure this out Question 3: How many mont...
Steven_Reid
Sep 27, 2018Copper Contributor
Hi,
not sure if you have already found an answer, but the following would work.
the following gives an answer of 9
=COUNTIFS(B64:B171,"="&D18,H64:H171,"<"&F18)