Excel Formula to Word Formula

  4damk 09:35 10 Jun 2016
Locked

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)

Example:

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

Thanks, Adam.

  wee eddie 14:35 10 Jun 2016

Depends on which version of Word that you are using but Word can do simple calculations

  lotvic 14:52 10 Jun 2016

For Office 2007: In Word click on Insert tab > click on the down triangle for dropdown menu under Table > click on Excel Spreadsheet.

Now enter your data and it will do the calculations as expected. (I've just done it so I know it works ok)

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Samsung Galaxy Tab S5e Release Date, Price & Spec

Rob Hunter talks animating his magical storybook style for a spacey Jon Hopkins music video

Best iPhone & iPad games 2019

Samsung Galaxy X : date de sortie, prix et fiche technique