LinkBack URL
About LinkBacks
Try this to get SUMIF for REG,
=SUMPRODUCT(--ISNUMBER(SEARCH("REG",A1:A148)),--LEFT(0&A1:A148,5))
For whole sum,
=SUMPRODUCT(--LEFT(0&A1:A148,5))
Note: There is 0& before the range.
Try this to get SUMIF for REG,
=SUMPRODUCT(--ISNUMBER(SEARCH("REG",A1:A148)),--LEFT(0&A1:A148,5))
For whole sum,
=SUMPRODUCT(--LEFT(0&A1:A148,5))
Note: There is 0& before the range.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks