Thread
:
Summing Numbers ending in letter
View Single Post
#
3
bbkdude
Junior Member
Posts: 3
Quote:
Originally Posted by
Claus Busch
try:
=TEXT(SUM(IF(RIGHT(H2:H370,1)="C",--LEFT(H2:H370,LEN(H2:H370)-1))),"#,##0C")
and enter the array formula with CTRL+Shift+Enter
Wow, fantastic. That did the trick! Thank you very much!
Reply With Quote
bbkdude
View Public Profile
Send a private message to bbkdude
Find all posts by bbkdude