excel SUM function - can it be limited to whats in parentheses?

excel SUM function - can it be limited to whats in parentheses?

Post by Dave Peter » Sun, 07 Jan 2007 03:31:04


I agree with what Dave F. wrote--life will be lots easier for lots of things if
you put your data in separate fields.

But this worked ok for me:

=SUMPRODUCT(--SUBSTITUTE(MID(A1:A3,SEARCH("(",A1:A3,1)+1,255),")",""))
Adjust the range to match your data



--

Dave Peterson
 
 
 

1. Excel add-ins does not show up in Excel>Tools>Add-ins list.

2. how do I give users that ability to create canned comments and ins

I have a specific application that uses INFOPATH very successfully.. The app is that field inspectors go out make observations and create .xml docs based on those observations.. my problem is that all inspectors have their own way of doing things or describing things. so I can create a canned list of selections from a drop down box, however, they never quite encompass what every inspector wants to say.. we have provided a free text box but the complaint we have recieved during our initial implementation is that the individual inspectors typically make the same comments and want to create their own list of things to say..

My question is:

how can I give each inspector the ability to create a list of pre canned comments that they can use to insert into a particular field.. is there an easy way to do this without the users having to learn how to program the fields..???

thanks

Chuck

3. I am interested in knowing some of your favorite Excel Add-ins

4. how to plot approximate periodical function knowing it's complex fourier coefficients using partial sum ??

5. I think it's an IF function but I am not sure

6. Excel 2002: Auto Sum function not working in large Excel file

7. it's very worthwhile today, I'll live wrongly or Lisette will measure the cans

8. It's true, it's true, what am I to do.

9. How can I get around 30 argument limit of SUM function?

10. does sum function have a limit?

11. Excel Add-Ins Incomplete Gamma Function

12. Add-ins function in Excel 2003

13. Know of any Bill-Of-Material (collapse & expand) functions/plug-ins for Excel?

14. HTML Help Workshop and Custom VBA Excel Functions/Add-Ins

15. 11050.6 Each statement requires it's own parenthesis