I WANT TO TOTAL WITHOUT ()

[Jagat Pavasia]

Dear sir,

I want to total my E8 to E26 at in E6.

I have digit in my E row with bracket.

I have inserted screen shot below.

pls help

 

[Jagat Pavasia]

In post #1 you did mentioned just upto row 26

Try

Book1
	A	B	C	D	E	F
1
2
3
4
5
6					7307.4
7
8					384.60 (17/11/2022)
9					384.60 (17/11/2022)
10					384.60 (17/11/2022)
11					384.60 (17/11/2022)
12					384.60 (17/11/2022)
13					384.60 (17/11/2022)
14					384.60 (17/11/2022)
15					384.60 (17/11/2022)
16					384.60 (17/11/2022)
17					384.60 (17/11/2022)
18					384.60 (17/11/2022)
19					384.60 (17/11/2022)
20					384.60 (17/11/2022)
21					384.60 (17/11/2022)
22					384.60 (17/11/2022)
23					384.60 (17/11/2022)
24					384.60 (17/11/2022)
25					384.60 (17/11/2022)
26					384.60 (17/11/2022)
27
Sheet3

Cell Formulas
Range	Formula
E6	E6	=SUMPRODUCT(IFERROR(LEFT(E8:E500,SEARCH("(",E8:E500)-2)+0,0))

don

DONE.....thank UUUUUUUUUUUUUUUUUUU

 

[Sufiyan97]

You're welcome
Glad we could help!

 

[awoohaw]

try:

=SUM(1*TEXTBEFORE(E2:E3," ["))

 

[Fluff]

The OP is using 2021 & so doesn't have that function.

 

[awoohaw]

The OP is using 2021 & so doesn't have that function.

arghh. I thought 2021 has all of the 365 functions. yikes.