Reply
 
Thread Tools Display Modes
  #1   Report Post  
tj3993
 
Posts: n/a
Default 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?
  #2   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



  #3   Report Post  
Greg Maxey
 
Posts: n/a
Default

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?



  #4   Report Post  
tj3993
 
Posts: n/a
Default

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?
  #5   Report Post  
Graham Mayor
 
Posts: n/a
Default

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?





  #6   Report Post  
macropod
 
Posts: n/a
Default

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


  #7   Report Post  
Margaret9121 Margaret9121 is offline
Junior Member
 
Posts: 19
Default

This showerhead features a large handle that is easy to grip, even for those with arthritis. The showerhead has seven different spray settings, including a pause setting that can help conserve water and reduce fatigue. low water pressure rv
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 11:50 PM
WordPerfect - copying formatting Morgan Page Layout 1 January 10th 05 06:00 PM
Excel worksheet in Word linked text boxes Eduardo Oliveira Page Layout 0 January 6th 05 12:23 AM
macro in word js Microsoft Word Help 1 December 28th 04 04:01 AM
formatting links from excel into word (extra line feeds) JGT Microsoft Word Help 1 December 9th 04 12:01 PM


All times are GMT +1. The time now is 10:59 PM.

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

About Us

"It's about Microsoft Word"