LinkBack URL
About LinkBacks
This will sum the entire range in a single cell
=SUMPRODUCT(--RIGHT(A2:A21,LEN(A2:A21)-SEARCH(")",A2:A21)))
This will sum the entire range in a single cell
=SUMPRODUCT(--RIGHT(A2:A21,LEN(A2:A21)-SEARCH(")",A2:A21)))
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks