Hi,
Could you help me convert this formula from SUMPRODUCT to SUMIFS so i can also use it in other cells afterwards as separate formulas replacing SUMIFS with AVERAGEIFS, MAXIFS and MINIFS? Thank You!
=SUMPRODUCT(--(ISNUMBER(SEARCH("*"&D7&"*";REVERT!$B$5:$B$10000)));IF(REVERT!$B$5:$B$10000="";"";--LEFT(REVERT!$B$5:$B$10000;5)))
Bookmarks