Hello,
Hope you all have a good day
I have a question related to Word Table formula.
Is it possible to create array formula in Word like we can do in Excel?
example:
The formula =product(B1:C1)+product(B2:C2)+product(B3:C3) works well.
Just want to know if the formula can be simplified into array formula like in Excel.
In excel we can use array formula ( with CTRL+SHIFT+ENTER):
{=SUM(B1:B3*C1:C3)}
Attach example in Word for review.
Thank you.
I've never used formulae in Word tables, but can't you use SUMPRODUCT? i.e.:
=SUMPRODUCT(B1:B3,C1:C3)
Hope this helps.
Pete
SUMPRODUCT is an Excel formula; Word has nothing equivalent. If you need functions equivalent to SUMPRODUCT, insert an Excel workbook into the Word document and use that. Otherwise, to see how to do a wide range of calculations in Word, check out my Microsoft Word Field Maths Tutorial, at:
http://windowssecrets.com/forums/sho...Maths-Tutorial
or:
http://www.gmayor.com/downloads.htm#Third_party
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Hello Pete_UK,
Thank you for your reply,
however sumproduct in Word resulting :
1*10*2*10*3*10 = 6000, rather than 1*10 + 2*10 + 3*10 = 60
Macropod,
Thank you for the link, but i can't download the zip.
also for the second link, i am not sure which file to download.
I did say Word has nothing equivalent to Excel's SUMPRODUCT...Originally Posted by qiyusi
Did you register there?
Given the tutorial's name, I'd have thought an entry on the second site's page named 'WordFieldMaths.zip' was pretty obvious:also for the second link, i am not sure which file to download.
http://www.gmayor.com/Zips/Word%20Field%20Maths.zip
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks