Answered step by step
Verified Expert Solution
Question
1 Approved Answer
urgent please DO THE FOLLOWING IN EXCEL PROVIDE A FORMULA TO ENTER IN CELL E3, TO COUNT ONLY IF MONTH IN COLUMN DATE 1 AND
urgent please
DO THE FOLLOWING IN EXCEL
PROVIDE A FORMULA TO ENTER IN CELL E3, TO COUNT ONLY IF MONTH IN COLUMN DATE 1 AND COLUMN DATE 2 ARE EQUAL.
SO THE FORMULA SHOULD COUNT 1 FOR ROW WITH DATE
1/5/2022 | 1/12/2022 |
1 FOR THE ROW:
3/16/2022 | 3/22/2022 |
AND 1 AGAIN FOR THE ROW
4/2/2022 | 4/20/2022 |
AND IN CELL E3 WE SHOULD SEE A RESULT OF 3 (WHICH IS THE SUM OF THE THREE 1s)
PLEASE DON'T CREATE ANOTHER COLUMN TO PULL THE MONTH SEPARATELY TO COMPARE (I KNOW HOW TO DO THAT), WHAT I AM LOOKING FOR IS GIVE JUST ONE FORMULA THAT SHOWS THE RESULT IN CELL E3, AND PLEASE SHOW A SCREENSHOT OF YOUR RESULT.
G8 1 2 3 4 5 167 8 LO 9 10 11 fxx B C DATE 1 DATE 2 1/5/2022 1/12/2022 3/15/2022 12/20/2022 3/16/2022 3/22/2022 4/2/2022 4/20/2022 5/17/2022 7/3/2022 D E COUNT SAME # MONTHStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started