Forum Discussion
Issue with Excel Product Function Syntax Using Multiple Logical Criteria
Environment: Windows 10, Microsoft® Excel® for Microsoft 365 MSO (16.0.14228.20216) 64-bit Having a peculiar issue with the Product function, and hoping for some help. Background: The at...
=PRODUCT(FILTER(C$5:C$76,(B$5:B$76=N20)*(A$5:A$76>=VLOOKUP(Per_Name,Chart_Period,2,0))*(A5:A76<=VLOOKUP(Per_Name,Chart_Period,3,0)))/10,000+1)-1