In Excel on the Question 1 worksheet, use the CountOddNumbers…

Question Answered step-by-step In Excel on the Question 1 worksheet, use the CountOddNumbers… In Excel on the Question 1 worksheet, use the CountOddNumbers function that will count the odd numbers for a selected range of cells. The code is below. Also, use your function to count for the odd numbers in the range B2:D4. Your answer should be in cell G5 on the Question 1 worksheet.  Public Function CountOddNumbers (rng As Range)Dim cell As RangeFor Each cell In rngIf cell.Value Mod 2 = 1 ThenCountOddNumbers = CountOddNumbers + 1 End IfNext cellend Function  Business Management Project Management MIS 301 Share QuestionEmailCopy link Comments (0)