formula

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel Misc
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - drop downs Hi, I would like to create a list of drop downs in the first column of an excel spreadsheet. I would like input a list for the drop downs and also have the icon for the drop down visible in each and every cell. Thanks.... -- MickM Tag: formula Tag: 784138
  - 2
    - help.. i have the following given : A B 1 asih 234 2 aa 334 3 bb 434 4 asih 534 5 cc 634 6 dd 734 7 asih 834 i managed to do the following : {INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=C1,ROW($A$1:$A$7)),ROW(1:1)),2)} and i dragged it to cell C3. NOW..... my purpose for this is to be able TO enter the word "asih" in C1 and C2 and C3 in order to be able its coresponding data which are : 234 , 534 , 834 MY QUESTION NOW IS : what should i do to insert the following formula : index(....),match(....) ) WITHIN THE PRECEDENT FORMULA: {INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=C1,ROW($A$1:$A$7)),ROW(1:1)),2)} AND THAT IN ORDER TO GET FOR EXAMPLE (734) IF I HAD TO TYPE (DD).???? THANKS FOR YOUR HELP Tag: formula Tag: 784137
  - 3
    - Merging Workbooks Hi!..Does anyone have any ideas on how you would do the following? I want to have 1 main work book (workbook 1) with only one sheet. On that sheet I want to create 3 buttons. Button 1 creates a link/marco to open another workbook (workbook 2) automatically when the button is clicked, button 2 creates a link/marco to open workbook 3 automatically when button is clicked and button 3 creates link/marco to open workbook 4 automatticall when button is clicked Is this even possible? Many thanks for any help in advance! Tag: formula Tag: 784134
  - 4
    - assign values to specific cells in an excel sheet through text file Hi list I am very new to macros or any visual basic codes. Kindly guide me with materials or ideas to assign values to specific cells in an excel sheet. For example, I wish to assign values 1,2,3,4.... into A1, B1, C1, D1...... in Sheet1 of C:\data.xls. with thanks pushparaj -- s_pushparaj Tag: formula Tag: 784133
  - 5
    - Formula/Macro to place data on the next blank row Hi everyone, I'll be grateful if someone can help me set up a formula/macro through which data can be placed on the next blank row. My intention is to create a database of info and update the list sometime before I choose new dat (ie, the existing quotation details can be saved in the database before the new quotation is generated). Thanks. Tag: formula Tag: 784131
  - 6
    - saving excel file Hi, I have some formulas and data which is shared for the users to get their answers instantly. Is there any way not to allow users to save the excel shared file if they make any changes. Is it possible if the users close the file with some changes excel exit without prompting or saving??. i tried read only, protect sheet etc. its of no use. Thanks Kevin Tag: formula Tag: 784129
  - 7
    - Pulling data by start/finish dates I have a spreadsheet of work orders with start dates in column G and finish dates in column H. I would like to be able to pull all records between certain start and finish dates - this would change each month (ie all records between April 1 (start) and April 30 (finish) and place on a blank sheet. I want to be prompted to enter the dates. How would I do this? Tag: formula Tag: 784124
  - 8
    - Min Value Here is an equation I'm using to calculate intersection sight distance: ISD = 1.47 (Vmajor) [T + (G - 3%)0.2 + (W/12)0.5] Each variable will be a cell, for instance, G could be B12. When G is less that 3%, I don't want it to do that part of the equation. The actual value of G could be 2.57%, but when it is, I don't it to "subtract 3%, then mult. by .2 In the EQUATION, i want that term, (G - 3%)0.2, to be a minimum of zero. See, when G is less than 3%, that whole term is negative, and i don't want that. Can anyone help me think of a way to not do that part of the equation when G < 3%? Is there some Excel function I'm not thinking of? I'm trying to avoid tons of nested IF statements. Much appreciated, dk Tag: formula Tag: 784119
  - 9
    - Space in text when I copy text from on sheet to anoth, the destination after the paste has one space in front of the text. how do i remove the space from multiple cells at the same time Tag: formula Tag: 784102
  - 10
    - is statement want to do this in a formular but dont know how: if the text in sheet 1 cell c2 = the text in sheet 2 column d, then return text in sheet 2 column e associated with text in column d. I've tried using vlookup, it works with some of the sheets but not all of them. I have to continiously copy text between the two sheets for it to work. Please help. Tag: formula Tag: 784100
  - 11
    - VLOOKUP Combining 2 Reports. How would I combine these two reports together using 05? Report 1 (Sales report) Item # Description 1 Qty Sold Publisher 12 360 BLAZING ANGELS 1 UBISOFT 25 360 CIVIL WAR 1 ACTIVISION 43 360 ELDER SCROLLS IV 1 TAKE 2 71 360 GHOST RECON AW 2 1 UBISOFT 78 360 HARDWARE ARCADE 1 MICROSOFT 91 360 LIVE 1 MONTH CARD 1 MICROSOFT 94 360 LIVE 3 MONTH CARD 1 MICROSOFT 97 360 LIVE POINTS 1600 3 MICROSOFT Report 2 (Qty On-hand) Item # Description 1 On-Hand Publisher 12 360 BLAZING ANGELS 6 UBISOFT 25 360 CIVIL WAR 2 ACTIVISION 43 360 ELDER SCROLLS IV 4 TAKE 2 71 360 GHOST RECON AW 2 3 UBISOFT I just need to add the on-hand qty from report 2 to report 1. Report one only generates items that have sold which is normally several hundred items. Report 2 will generate the entire inventory database which is more than 10,000 items. Do I have to use item # to use VLOOKUP? If Column A was a UPC # or Description instead of item # how would I use VLOOKUP? Tag: formula Tag: 784099
  - 12
    - If statement in macro Hi I want the macro to type in column on "c" the status "On Time" or Delayed" depending of the following criteria: - if A= MTL and B = 2 then C= "on Time" - if A<> ATLN OR VAN and B =1 then C ="on time" - if A=ATLN ot VAN then C="out of ON PU" - Else "Delayed" A B c MTL 2 ATLN 5 VAN 7 LOND 1 I wrote the below proceduce but there is an error. Could anyone help me to write this procedure properly. Thanks in advance. Sub Job() Range ("C1).Select ActiveCell.Value = "=if ActiveCell.Offset(0,-2)= "MONT" and ActiveCell.Offset(0,-1)=2 then Active.Cell.Value="On Time" Else if ActiveCell.Offset(0,-2) <> "ATLN" or If ActiveCell.Offset(-2,0)<> "VAN" and ActiveCell.Offset(0,-1)=1 then ActiveCell.Offset.Value="On Time" Else if ActiveCell.Offset(0,-2) = "ATLN" or If ActiveCell.Offset(0,-2)= "VAN" then ActiveCell.Value="Out of ON PU" Else ActiveCell.Value="Delayed" End if End () Orquidez Tag: formula Tag: 784098
  - 13
    - How do I separate numbers? I have a web query which gives me the result "385/1700" and all I want is the first part "385" to allow me to do calculations with, but because it's a web query, it wont let me just format it as a fraction and times it by 1700.. it comes up with the #VALUE! error. So I dont know what else to try, Can anyone help? Thanks, Aden Tag: formula Tag: 784096
  - 14
    - Automatic Display of ApproveIt Menu upon Excel Opening How do I eliminate the ApproveIt Menu from automatically appearing every time I open Excel? -- Bonnie Tag: formula Tag: 784095
  - 15
    - is this filter possible? I have a list of customers on sheet 1 cell A1. I need a filter that will display specific cells for specific customers. For instance, when the list in A1 reads ABC Lumber Co., I would like to see cells columns A through F lines 601 through 622 directly below the list cell. Is this possible? -- bob Tag: formula Tag: 784085
  - 16
    - calculate moles in excel HELP! How in Excel do I work out how many moles are in 1kg of water. Desperately need an answer for Monday morning. :) Tag: formula Tag: 784083
  - 17
    - Disabling Automatic Date Thing When i type '5-10' for example, and then press enter or leave that box, the '5-10' i typed automatically changes to '05-Oct'. It's really irritating and it happens with others, such as '10-15', basically anything that looks like a date. How do I turn this off? Tag: formula Tag: 784079
  - 18
    - Disabling Automatic Date Thing When i type '5-10' for example, and then press enter or leave that box, the '5-10' i typed automatically changes to '05-Oct'. It's really irritating and it happens with others, such as '10-15', basically anything that looks like a date. How do I turn this off? Tag: formula Tag: 784078
  - 19
    - Row-Entire row changes color (and stays) selecting first entry I have a sheet with 63 rows and 30 columns. I would like the row to change color and stay as I slide across columns. Freeze panes works almost but to change color would be better. Tag: formula Tag: 784077
  - 20
    - Numeric formatting Hi, I need to format numbers as 10E-3, 10E-5, or 10E-6. I need to maintain the 10E-x format. Not scientific or engineering notation. It's for recording Bit Error Rate measurement results. Any ideas? Thank you for your help. Tag: formula Tag: 784074
  - 21
    - Excel "If" Function formula Hi I need some help figuring out if it is possible to create a formula. I'm trying to link information from different pages in a spreadsheet that contain id's for people and prices they are paying for some items my church is selling. We have a main worksheet that lists their names and the ids and then we have another worksheet that lists all the items they can buy with it's price. Is it possible to create a formula in the name page that says "If you find id #1 in column A, then sum the prices from column D". The ids will be spread out throughout column A so we need a formula to locate each instance of the id and then grab the price listed each time in column D and sum those prices up. Is this possible and if yes can someone tell me how to do it. Thanks Tag: formula Tag: 784068
  - 22
    - Min Sumproduct formula returns a zero. I have a spreadsheet. Which can be viewed on my public box link http://www.box.net/shared/movk8u3cws My headings are A3 Date, B3 Name, C3 Contribution E3 12/08/07 Date=A3 Name=B3 Contribution=C3 12/8/2007=E3 Andy=F3 12/8/2007 Andy 1 12/8/2007 Andy 40 12/8/2007 Andy 3 12/8/2007 Andy 4 Date=A11 Name=B11 Contribution=C11 12/8/2007=E11 Andy=F11 12/8/2007 Andy 1 12/8/2007 Andy 40 12/7/2007 Andy 3 12/8/2007 Andy 4 In E3, I entered 12/08/07 and in F3 I entered Andy. I want my formula in J11 which is =SUMPRODUCT(MIN((B6:B9=F5)*(C6:C9=G5)*(D6:D9))) to return the minimum contribution that Andy made on 12/08/07. When I substitute Min for Max, the formula works with no problems at all. As soon as I switch to Min the formula returns a zero. It will work if all the dates and all the names are the same. But as soon as the Date or Name changes I get a zero fpr the Min formula. I even entered it as an array but it won't work. Tag: formula Tag: 784062
  - 23
    - vba programming in excel 2007 how i can use vba programming in excel 2007 to sort in column in ascending order give me reply as a i am beginner. Tag: formula Tag: 784058
  - 24
    - Count after given condition is met Hi all would like your help for the following Need to count which and how many numbers appear after a given number ie After After After After After After 1 2 3 4 5 6 1 2 1 1 3 1 1 1 1 4 1 2 3 1 1 5 2 1 6 1 this was obtained from data on column c, that is displayed as follows: 3 5 4 5 3 4 4 2 4 3 4 4 3 5 6 4 4 3 3 4 2 3 2 Tks in advance Antonio Tag: formula Tag: 784053
  - 25
    - Excel - how to autofill thousands of cells quickly I have a spreadsheet with 35000 rows. Is there an easy way to autofill a formula for all of the rows instead of dragging down all 35000 rows? Tag: formula Tag: 784040
- Next
  - 1
    - Pivot Table % Calculation Issue I am bringing in the data below from SQL Server. I cannot add a calculated field because it is removed when it is refreshed. The issue is with the SUM of the GP% ((GP $/Sales)*100). I manually added another column to the right for only the ones that are wrong and what it needs to be. Spent too many hours trying to resolve this one. Data Store Order No Description Sales GP $ GP% GP% Needs to be BR 00000231 SPRING RED 11.99 6.49 54.13 00000231 Total 11.99 6.49 54.13 00000232 SPRING RED 11.99 6.49 54.13 00000232 Total 11.99 6.49 54.13 00000233 BALL RACK 49.99 24.99 49.99 00000233 Total 49.99 24.99 49.99 00000234 BLUE PUP 39.99 19.49 48.74 00000234 Total 39.99 19.49 48.74 00000236 BLUE PUP 39.99 19.49 48.74 SPRING RED 11.99 6.49 54.13 SPRING YEL 11.99 6.49 54.13 00000236 Total 63.97 32.47 156.99 50.76 00000237 READ RACK 14.99 7.49 49.97 BLUE PUP 39.99 19.49 48.74 SPRING RED 11.99 6.49 54.13 00000237 Total 66.97 33.47 152.83 49.98 00000238 BALL RACK 49.99 24.99 49.99 00000238 Total 49.99 24.99 49.99 00000239 SPRING YEL 11.99 6.49 54.13 00000239 Total 11.99 6.49 54.13 BR Total 306.88 154.88 620.93 50.47 Grand Total 306.88 154.88 620.93 50.47 Any suggestions would be greatly appreciated. Jeannette Tag: formula Tag: 784035
  - 2
    - comparing from two worksheets Hi all, I am trying to compare from two worksheets. What I have is the inventory that my headoffice is telling me I have and the other is the actual inventory I have I want to compare the two by product number and discription giving the head office total per item, my total per item and the difference between the two. I have a general knowledge about this but I thinking its over my head. Help required. Thanks Tag: formula Tag: 784032
  - 3
    - display specific next highest value from a column containing multi Just cant seem to get it. I am working with data in F10:F100 that contains numbers like (1,2,3,4) as well as lettered numbers like (C1,C2,C3,C4). I can not come up with a formula that will index this column and return the next highest C number. F9 needs to display the next highest C number. I can get this to work with the standard numbers only (1,2,3,4). Any suggestions Tag: formula Tag: 784030
  - 4
    - e mail same body different subject Hello I copied the code below. Now is it possible to change the line Subj = "Your Annual Bonus" Here is the thing, the body of the e mail will be the same for everyone but the subject will be different. How do I do that? thanks Sub SendEmail() Dim cell As Range Dim Subj As String Dim EmailAddr As String Dim Recipient As String Dim Bonus As String Dim Msg As String Dim HLink As String For Each cell In Columns("B").Cells.SpecialCells(xlCellTypeConstants) If cell.Value Like "*@*" Then 'Get the data Subj = "Your Annual Bonus" Recipient = cell.Offset(0, -1).Value EmailAddr = cell.Value Bonus = Format(cell.Offset(0, 1).Value, "$0,000.")V Tag: formula Tag: 784025
  - 5
    - working with graphics and formating them how to create amortization tables Tag: formula Tag: 784022
  - 6
    - Validation malfunction I'm using Excel 2004 11.4.1 on Mac OSX 10.4.11. On a page with several columns of cell validations, randomly, one cell will control the input to a different cell or shows a double pull down arrow on the right and will not clear or delete. What's going on? Is there a fix for the software and the affected files? Tag: formula Tag: 784021
  - 7
    - Customize a macro button I would like to create my own symbols so that when I add a macro button to the command line it's easier for me to understand. Is there a way that I can create my own symbol so that it's available in the modify button dialog box? Tag: formula Tag: 784016
  - 8
    - Where did MS hide it in 2007 ?? In 2003 -- View > Toolbars > FORMS Where is the above in Office 2007? Bob Tag: formula Tag: 784012
  - 9
    - Compatibility Checker Where is the "FIND" in the Compatibility Checker. Some of the formulas in this workbook are linked to other workbooks that are closed. When these formulas are recalculated in earlier versions of excel without opening the linked workbook, character beyond the 255 character limit can not be returned. The help portion of excel instructs to do the following to resolve! In the Compatibility Checker, click Find to locate cells that contain array formulas that refer to another worksheet, and then make the necessary changes to avoid #VALUE! errors. Can anyone walk me throught the steps so that I can correct and remove the links - how do I find where the links are> Tag: formula Tag: 784010
  - 10
    - Deleting and Copying Marco code Hi, Can any one please help me with writing a code in visual basics? What i am trying to do is this: I want to create a button called 'close' in row 1(sheet 1) and when I click this I want a marco to run which will delete the entire row that the button is on and then paste that row into row 5 in worksheet 2. I want to repeat this for the next row however, when the second row is pasted into worksheet 2 i want the second row to be pasted in row 5 and the first row move down to row 6... I hope this makes sense and would really appreciate any assistance from anyone as i am not to familiar with writing up codes...THANK YOU in advance! Tag: formula Tag: 784007
  - 11
    - Help, please Worksheet is sorted by dates in Col. A. Dates have varying number of rows; i.e., 5-6-08 may have 29 rows of data; 5-7-08 may have 14 rows; and 5-8-08 may have 42 rows. How can I automatically transfer to another worksheet the values in the last row for a date? Tag: formula Tag: 784004
  - 12
    - Popup Input Box Hi, I'd like to have a message box popup whenever the word INPUT appears in a certain cell. Cell A1 have a formula to lookup another cell. If that cell does not have a value, cell A1 will show the word INPUT. Whenever A1 shows INPUT, i want a message box to appear to request for user input. I know how to create the form for the input and i know how to place the input value into cell A1, but I just do not know how to get the message box to popup. Also, I need excel to automatically monitor row by row, ie, users will key in row by row. So, if A1 shows INPUT, the message box will appear. then after they key in the INPUT and go on to the next row, if A2 shows INPUT again, another message box will appear. Thanks. Dolphin Tag: formula Tag: 783998
  - 13
    - Creating a code for a macro Hi, Can any one please help me with writing a code in visual basics? What i am trying to do is this: I want to create a button called 'close' in row 1(sheet 1) and when I click this I want a marco to run which will delete the entire row that the button is on and then paste that row into row 5 in worksheet 2. I want to repeat this for the next row however, when the second row is pasted into worksheet 2 i want the second row to be pasted in row 5 and the first row move down to row 6... I hope this makes sense and would really appreciate any assistance from anyone as i am not to familiar with writing up codes...THANK YOU in advance! Tag: formula Tag: 783997
  - 14
    - Creating Amortization tables in excel 2003? how do I create amortization tables in excel 2003 Tag: formula Tag: 783995
  - 15
    - excel doubts i would like to know if the following 2 procedures are possible and, if possible, how to carry them out- 1) for example, if i type the name of a month, say may, and in the next cell i type a no., say 5, it should automatically fill out like this-'05-05-2008' 2) if i've prepared different sheets regarding different customers but i would like to type the whole data in 1 sheet the data pertaining to different customers should automatically transfer to their respective sheets waiting for your reply mehvish Tag: formula Tag: 783989
  - 16
    - Linking I am using Excel97 and want to know how to change links to another worksheet in the same workbook? For example, I have worksheet OTB DEC and OTB JAN in workbook OTB1. In a separate workbook, I have linked the values from worksheet OTB DEC in column A. In column B I need the same exact cells linked, but from the the worksheet OTB JAN. How can I do this without having to either relink column B or type over "OTB DEC" with "OTB JAN" in every cell? I cannot use change source because they are both from the same workbook, OTB1. Tag: formula Tag: 783970
  - 17
    - Reverse Pivot-type Data (that's not a pivot table) Data is not in an actual pivot table (so it can't be reversed to get what I want), it's just entered in a crosstab format: June July August Andy 2 3 4 Dave 3 6 2 Any easy way to convert it to this format? Name Month Sales Andy June 2 Andy July 3 Andy August 4 Dave June 3 Dave July 6 Dave August 2 TIA. Tag: formula Tag: 783968
  - 18
    - sum if with multiple criteria how can I use multiple criteria and the sum if function. how could I sum for "red apples"? ColA ColB ColC red apples 5 green apples 2 baby carrots 1 red apples 3 Thanks -- djk Tag: formula Tag: 783959
  - 19
    - Saving Formulas when addin rows I have a ss that I need to keep track of 12 weeks on information. Each week I need to add a new row either by moving the remaining rows down or deleting th lar row and insert another row. Either way I do it I lose my formulas for the new row. Example Row 2 has formulas in columns F, G, H I now move the data in row 2 down, the formulas in F, G, H are gone as well. On the bottom of the SS I have formulas to add certain rows together. Before I move row 2 all columns have correct formulas. I add the new row which no becomes Row, the formula is no longer in row 2 and I have to edit every row to include row 2. Sorry to be so wordy but I need help! Thanks Tag: formula Tag: 783958
  - 20
    - PivotTables and Sum/Count 2 columns I have an Excel worksheet with four columns; Relationship ID, Account Name, Summary of Market Value and Account ID: Realtionship ID Account Name Summary of Market Value Account ID SEAR Sears $3250 20010 SEAR Sears $5345 20010 PENN Pennys $3236 20011 MARS Marshalls $4444 21222 MARS Marshalls $3244 21222 What I would like is to find the total count by Account Name with their Individual and Total Revenue I have created a PivotTable using Account ID in the Data field, and the rest of the fields in the Row field, Relationship ID, Account Name, and Summary of Market Value. The PivotTable displays almost all of what I am looking for with the Relationship Code - Total, Account Name and Sum of MarketValue per Account name and then the final column contains the count of the Account ID. What I am missing is the total of the Sum of MarketValue for each Relationship ID. Is there a way of adding this? Thanks Tag: formula Tag: 783949
  - 21
    - HELP! In desperate need of a formula I'm working on a settlement statement that is 112 pages. Column G=the attorneys' name and Column F=rates for the different attorneys. Different attorneys have different rates. At the end of my statement, I have a section that needs to tally each attorey's fee for a total. I can't come up with a formula that will calculate this. Please help! I'm up against a hard deadline! Thanks in advance! Tag: formula Tag: 783945
  - 22
    - formula fill down =IF(DataInput!D3="Standard",R4+R4*19.25%,IF(DataInput!D3="Recommended",R4+R4*Q4,0)) how do i reference a cell in a formula and not have it change all down the columns? Tag: formula Tag: 783938
  - 23
    - Inconsistent Cell Functions I have a template that we use for financial reports. When we input data we sometimes hit enter and sometimes use the arrow keys. Although I am not aware of any template changes, all of a sudden when we hit the down arrow, EXCEL adds that line to the formula. Example. CELL B4 input 143 then hit the down arrow and B4 will read 143+B5 This is not true on every cell. We have other Excel Documents that the down arrow juts moves to the next cell. This is new and we are wondering how to make it consistent. When we hit down, it should just go to the next cell. Please advise. Tag: formula Tag: 783935
  - 24
    - Pivot Table question or a simpler suggestion Hello, I have a group of data. Among the data fields are the following: Name Group/Association Number of rankings The number of rankings are either 0, 1, or 2. I would like to be able to know for a given group, how many members of the group have at least 1 ranking. My first thought was a Pivot Table but if I use the count field setting, it counts all populated cells. If I leave the cell blank, that works instead of using a zero but I would prefer not to leave it blank as it may cause confusion to others I pass the sheet on to. I thought about writing something in VBA but this seems a little advanced for my vba skills. Is there a way to count only non zero values with a pivot table? Is there a simpler solution that I may be overlooking? Thanks. -Mike Tag: formula Tag: 783934
  - 25
    - XIRR - Function Missing Hello, I used XIRR many times in the past but today when i tried to use it, i couldn't. I checked the Data -->AddIns and the ATP is clicked so i don't understand why it's not working. I'm using Excel 2003 and as mentioned before - used XIRR many times in the past. I also tried to check and uncheck the ATP and even restart the computer, and I still can't find the XIRR.... any ideas why this is happening and how I can fix it? HELP!! Thanks! Tag: formula Tag: 783932

Hi,

I would like to create some formulas that regonises a word in the first
column and then adds up the number across from it.

Thanks....
--
MickM

Top

RE: formula by MikeH

MikeH
Sun May 11 03:33:00 CDT 2008

Possibly

=SUMPRODUCT((A1:A20="Myword")*(B1:B20))

Mike

"Mick" wrote:

> Hi,
>
> I would like to create some formulas that regonises a word in the first
> column and then adds up the number across from it.
>
> Thanks....
> --
> MickM

Top

Re: formula by Bob

Bob
Sun May 11 08:51:43 CDT 2008

why wouldn't you use SUMIF?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Mike H" <MikeH@discussions.microsoft.com> wrote in message
news:29DB1CAD-58AB-443F-BB36-83FC41644668@microsoft.com...
> Possibly
>
> =SUMPRODUCT((A1:A20="Myword")*(B1:B20))
>
> Mike
>
> "Mick" wrote:
>
>> Hi,
>>
>> I would like to create some formulas that regonises a word in the first
>> column and then adds up the number across from it.
>>
>> Thanks....
>> --
>> MickM

Top