Reply
 
Thread Tools Display Modes
  #1   Report Post  
Jean-Guy Marcil
 
Posts: n/a
Default

tj3993 was telling us:
tj3993 nous racontait que :

I'm trying to sum a table column based on information contained in
another column. Does Word have a function similar to the SUMIF
function in Excel?


No. But you can build an IF field that would work. Nested IF fields are
allowed in Word, just as in Excel.


{IF {SUM(abc)}= 123 "Output this" "Else output this"}
or
{IF [This]= "That" "{SUM(abc)}" "Else output this"}
etc.

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site:
http://www.word.mvps.org



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
word xp crashes after macros are recorded kharris0405 Microsoft Word Help 3 January 11th 05 10:50 PM
WordPerfect - copying formatting Morgan Page Layout 1 January 10th 05 05:00 PM
Excel worksheet in Word linked text boxes Eduardo Oliveira Page Layout 0 January 5th 05 11:23 PM
macro in word js Microsoft Word Help 1 December 28th 04 03:01 AM
formatting links from excel into word (extra line feeds) JGT Microsoft Word Help 1 December 9th 04 11:01 AM


All times are GMT +1. The time now is 10:23 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"