K Kenshin Member Oct 29, 2018 #1 Nice seeing you again ninjaz hope get help from you again, please see my file in attachment to get clear. thanks guys Kenshin Attachments Asking Help.xlsx 9.9 KB · Views: 10
Nice seeing you again ninjaz hope get help from you again, please see my file in attachment to get clear. thanks guys Kenshin
Hui Excel Ninja Staff member Oct 29, 2018 #2 H3: =SUMPRODUCT(--(C3:G3<$C$2:$G$2)) copy down I think you also want C14: =COUNTIFS(C3:C12,"<"&C2) copy across
H3: =SUMPRODUCT(--(C3:G3<$C$2:$G$2)) copy down I think you also want C14: =COUNTIFS(C3:C12,"<"&C2) copy across
