VBA-Summing Data in Table in Ms word Contains Text. etc..

[Susanto3311]

hi all..

how to summing data into table with criteria:
summing with data contains text, N/A, blank,'etc..

i want to the macro whit this step:
1. select range that do you want summming .
here attacment file
any help, thanks in advance

susant

[HansV]

Why do you want to do this in Word? Excel would be more appropriate.

In what form do you want the output, and what should it look like?

[jolas]

This may help

[macropod]

You could use a series of formula fields, coded along the lines of:
{=SUM(B2:B6)}
Although these will update automatically when you print the document, the updates aren't dynamic as they are in Excel. Depending on what you're trying to achieve, you might do better to embed and Excel worksheet in your document or use a separate Excel workbook and insert LINK field pointing to that.

To see how to do a wide range of calculations in Word, check out my Microsoft Word Field Maths Tutorial, at:
https://www.msofficeforums.com/word/387 ... orial.html
or:
http://www.gmayor.com/downloads.htm#Third_party

[Susanto3311]

thank you guys.

[Susanto3311]

hi guys..
for a reason calculated must in Ms Word format..I know this not appropriate like Hans said...
but in my department for this case i must do with Ms word .this multiple pages
i found problem like this . how to summing with ignoring N/A or Blank Cell...What formula to use?
my picture just a sample.

note:
calculate for summing & calculate for average

[jolas]

Watch the video link I posted earlier.

[Susanto3311]

yes of course but not for blank cell or n/a

[StuartR]

The obvious formula seems to ignore blank cells and N/A quite happily. Did you test this?

[jolas]

I hope the attached file will make sense.

[macropod]

The obvious formula seems to ignore blank cells and N/A quite happily. Did you test this?

The SUM(ABOVE) formula is quite unreliable for table data such as the OP supplied in post #1. This is documented and explained in my Microsoft Word Field Maths Tutorial (see link in post #4)

[StuartR]

This is documented and explained in my Microsoft Word Field Maths Tutorial (see link in post #4)

Sadly, that link doesn't work for me, it asks for a login that I don't have

[macropod]

for a reason calculated must in Ms Word format..I know this not appropriate like Hans said...
but in my department for this case i must do with Ms word .this multiple pages

Using an Excel worksheet embedded in the Word document may satisfy that requirement; otherwise, the formula I provided in post #4 will provide the required summation. Averaging is simply a matter of substituting AVERAGE for SUM.

See attached demonstration of both approaches.

summing word.docx

[macropod]

Sadly, that link doesn't work for me, it asks for a login that I don't have

I've added a second link that doesn't require a login.

[StuartR]

I've added a second link that doesn't require a login.

Thank you, that works

[Susanto3311]

hi guys...thank you so much.
It's make me clear and knowing what's my problem.

[Susanto3311]

hi guys,,
in progress i found new problem, how to determine total average I + average II
note:
formula for average I and II is correct but for average I+II is not correct! '-last paragraph'
average I in page 8 & average II in page 9
my target in yellow shading in col. F
i have do with combination formula sum, average but not work true.
please, check in yellow shading

[macropod]

For example:
{=AVERAGE(f5:f39,f42:f46)}

[Susanto3311]

hi paul, thanks but not true..
average I = 80
average II = 113
average total = (113+80)/2 = 96.5 --'should be'

since your formula the result is 85.5

[macropod]

Your 96.5 is an average of your averages, not an average of the values. 85.5 is the average of the values. Most would regard such an average of averages as a meaningless figure, since it takes no account of how many items contribute to each of the averages. Still, if that's what you want:
{=AVERAGE(C40,D47)}
or:
{=SUM(C40,D47)/2}
Note that the cell references are not to the same column due to inconsistencies in your table layout.