Hello,
I wasn't able to find a solution to my issue on any forum. I am looking to return the count of shipments that went out on a Monday and meet two criteria.
=SUMPRODUCT(--(WEEKDAY(Table1[[Date Order Entered ]],2)=1)*1,(Table1[Detail Branch]=$C$6)*1,(Table1[Order Prep. Status]=$G6)*1)/COUNTIFS(Table1[Detail Branch],$C$6,Table1[Order Prep. Status],$G6)
but it gave me a percent and I want the absolute number.
Thanks,
pb
Bookmarks