Hi I'm trying to get the attached word document 1 for each day I've worked in one excel sheet. I've got as far as converting them to txt files. And I can import them one at a time.
But I'm at a loss how I can import them all in one go into one excel sheet..?Any help is appreciated.
Thanks in advance for your time.
Well I got them all in one excel file by converting them to pdf and than using 3th party software to get them batch imported into excel but since they than
each have a sheet in a excel folder I used VB to convert them in one worksheet but now I would like to finally add up the colored fields but for some reason I can't seem to add up the red colored fields. I used the formula in the yellow colored field. But obviously it's wrong. Any help would be appreciated!
There is no numeric values in column J to add up, all there is "text" that looks like numbers. This might fix it for you:
1) Highlight column J and press CTRL-H
2) Search for "€ " (that's a euro followed by a space) and replace with nothing... that may convert them all to actual numbers.
If the formula in L2 doesn't start working right off:
3) Change the formula to: =SUMIF(J:J,"<>",M:M)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Ty that did the trick thanks for the help!
As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks