Below is a possible solution to the Challenge 64 – Sum up the Range where a particular alphabet appears
=SUMPRODUCT(ISNUMBER(SEARCH(" "&C2&","," "&A2:A13&","))*(B2:B13))
Below is a possible solution to the Challenge 64 – Sum up the Range where a particular alphabet appears
=SUMPRODUCT(ISNUMBER(SEARCH(" "&C2&","," "&A2:A13&","))*(B2:B13))
Good Page
thank you for kindness!
and I have question? do you have 5000 csv file students academics record?
I want it for research purpose