Excel Formula to Word Formula

801 Views 2 Replies 3 Participants Last post by macropod, Jun 10, 2016

4damk

Discussion Starter · Jun 10, 2016

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

)

Example:

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

Save

Status: Not open for further replies.

1 - 3 of 3 Posts

Masterchiefxx17

· #2 · Jun 10, 2016

You'll have to do this:

https://support.office.com/en-us/ar...orksheet-41bf021e-ba7c-44ef-9914-0d7e88062257

Save

macropod

· #3 · Jun 10, 2016

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
or:
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.

Save

1 - 3 of 3 Posts

Status: Not open for further replies.

Top Contributors this Month