amending a formula

[jupops]

Good Morning All

I created a formula a long time ago, which now I need to amend. This is where I am finding a bit of a problem.

the fomula

=SUMPRODUCT((LEFT(spool.xls!E1:E22000,1)="E")*(spool.xls!H1:H22000>0))

would count up all the cells in column E which started with c, thath were above 0 from column H,

I need to count them if the first TWO chars are E0. If anybody have an idea I would be graetful. Thank you

Jupops

 

[GlennUK]

well, have you tried anything yet? The first thing I would try would be to change the number of characters the LEFT function is retrieving. Currently it's fetching 1 character, so change the 1 to a 2, like this
.....LEFT(spool.xls!E1:E22000,2).....

and change the "E" to "EO"



Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.