Does Word have something like SUMIF in Excel?

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?

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

I don't think so. You can use cell ranges in forumlat fields. For example,
say you want to sum column a rows 1 trough 5 in cell b1.

In b1, put the field {=sum(a1:a5)}

--
Greg Maxey/Word MVP
A Peer in Peer to Peer Support

tj3993 wrote:
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?

Merci. I understand what you wrote, but I'm not sure how to apply it to what
I am doing.

Here is what I am trying to do.

I have rows of items that are categorized (for argument, let's call them
"A", "B", and "C"). I want to create totals by category. In Excel, to sum
all records in Category "A" I would type:

=SUMIF(B1:B100, "A", C1:C100),

where B1:B100 contains the category for each record and C1:C100 contains the
value for each record.

Is this possible to do?

Why don't you simply perform your calculations in Excel and paste the link
from Excel into Word?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




tj3993 wrote:
Merci. I understand what you wrote, but I'm not sure how to apply it
to what I am doing.

Here is what I am trying to do.

I have rows of items that are categorized (for argument, let's call
them "A", "B", and "C"). I want to create totals by category. In
Excel, to sum all records in Category "A" I would type:

=SUMIF(B1:B100, "A", C1:C100),

where B1:B100 contains the category for each record and C1:C100
contains the value for each record.

Is this possible to do?

Hi tj,

Word doesn't have anything equivalent to a SUMIF function, though you could
build up an approximation for testing numeric values via something like:
{=IF(B14,C1,0)+IF(B24,C2,0)+IF(B34,C3,0)+IF(B4 4,C4,0)}

However, I note that you're possibly trying to test whether the data in
Column B is a letter (or alhpa-numeric string). The standard column & row
cell referencing does not work with text strings, including dates and other
mixed alpha-numeric character strings. To refer to a character string in a
cell, the character strings (not the cells) must be individually bookmarked
and the bookmarks referred to in the formula. For what you're trying to do,
this might be a lot of work - a macro (or a link to an Excel workbook with
the SUMIF implementation) would be far better.

Cheers


"tj3993" wrote in message
...
Merci. I understand what you wrote, but I'm not sure how to apply it to
what
I am doing.

Here is what I am trying to do.

I have rows of items that are categorized (for argument, let's call them
"A", "B", and "C"). I want to create totals by category. In Excel, to
sum
all records in Category "A" I would type:

=SUMIF(B1:B100, "A", C1:C100),

where B1:B100 contains the category for each record and C1:C100 contains
the
value for each record.

Is this possible to do?


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.799 / Virus Database: 543 - Release Date: 19/11/2004