Tech Support Forum banner

Excel Formula to Word Formula

801 Views 2 Replies 3 Participants Last post by  macropod
I have created a formula in Excel that works fine, but when I put it into a MS Word table, it doesn't seem to work. The formula adds up a column of prices when the resulting column has a specific word in.

The formula is:
=SUMIF(E:E, "Yes", D:D)


Is this possible to do? If so can anyone help converting this so it will work in MS Word.

Thanks, Adam.
See less See more
Not open for further replies.
1 - 3 of 3 Posts
Word has nothing equivalent to Excel's SUMIF function. To see how to do a wide range of calculations in Word, check out my Microsoft Word Field Maths Tutorial, at:
Microsoft Word Field Maths Tutorial | Windows Secrets Lounge
Graham Mayor - Downloads

If you need Excel functionality in your Word document, you can embed an Excel worksheet in the document or link to the relevant portion of an external workbook.
1 - 3 of 3 Posts
Not open for further replies.