- There is not the slightest explanation in your sheet
- You should explain what you are trying to do in words in your post. That way, members do not have to open your file to try to understand what you are trying to do
- Please also add manually calculated expected results
SUHAS KARHADKAR
Based Sheet2:
for cells J2 =SUBSTITUTE(MID(H2,2,9)," - ","")*1 and copy down
above sample with cell J3.
... and that total sum You seems to know.
Thanx Pecoflyer Sir.
Also thank you Bosco Sir, given your SUMPRODUCT formula (Sheet 2) I am getting the Total of the column. Thank you.
Thank you very much Vletm Sir, I accomplish what I need by your given formula for Sheet 2.