View Single Post
  #5   Report Post  
Max
 
Posts: n/a
Default

Put in the formula bar for V10:

=SUM(IF(--(LEFT($D10:$Q10,1)=V$9),--SUBSTITUTE($D10:$Q10,V$9,"")))


Clarification:

Think we could drop the "--(...)" for the
... LEFT($D10:$Q10,1)=V$9) .. part

So, maybe revise the formula in V10 to:

=SUM(IF(LEFT($D10:$Q10,1)=V$9,--SUBSTITUTE($D10:$Q10,V$9,"")))

Array-enter with CTRL+SHIFT+ENTER, as before

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----