Home 
Search 
Today's Posts 
#1




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




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! _______________________________________ JeanGuy Marcil  Word MVP ISTOO Word MVP site: http://www.word.mvps.org 
#3




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




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




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




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 alhpanumeric string). The standard column & row cell referencing does not work with text strings, including dates and other mixed alphanumeric 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 antivirus system (http://www.grisoft.com). Version: 6.0.799 / Virus Database: 543  Release Date: 19/11/2004 
Reply 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Forum  
word xp crashes after macros are recorded  Microsoft Word Help  
WordPerfect  copying formatting  Page Layout  
Excel worksheet in Word linked text boxes  Page Layout  
macro in word  Microsoft Word Help  
formatting links from excel into word (extra line feeds)  Microsoft Word Help 