I'm not sure how to explain this! I need a total of the number of times that "G" (no quotes) appears in the range S4:S1516, based on "Ou" (no quotes) appearing in the same row, in the range J4:J1516. Many thanks Rendon

0 |

10/27/2007 1:04:04 PM

=SUMPRODUCT(--(S4:S1516="G"),--(J4:J1516="Ou")) -- Gary''s Student - gsnu2007a

Superb!! Rendon "Gary''s Student" <GarysStudent@discussions.microsoft.com> wrote in message news:A1F9901E-86C2-462D-8D5D-E6EB9535A2CF@microsoft.com... > =SUMPRODUCT(--(S4:S1516="G"),--(J4:J1516="Ou")) > -- > Gary''s Student - gsnu2007a

0 |

10/27/2007 1:21:09 PM

How do I take a cells numeric value and see if it falls inbetween a range of cells values. IF(A1 falls between A2:A3, Yes,No) A1 = 6 A2 = 1 A3 = 10 -- BFiedler ------------------------------------------------------------------------ BFiedler's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27262 View this thread: http://www.excelforum.com/showthread.php?threadid=469393 I don't understand this forum..what is the deal..no one ever replies to my questions. :mad: -- BFiedler ------------------------------------------------------------------------ BFied...

Hello, In A1 I will have one of the following number: 0, 1, or 2, which represents the number of clients lost. In cell B1 I have the text "0 Clients lost" In Cell B2 I have the text "1 Clients lost" In Cell B3 I have the text "2 Clients lost" In C1 I have $800 (which goes with B1) In C2 I have $300 (which goes with B2) In C3 I have $0 (which goes with B2) In D1, I would like to return the value of the above. For example if "0" is selected in A1, then D1 will return $800. Thanks for the help. Jim hi try this..... =IF(A1=0, C1,...

I'm very new to Excel and have taken a long time to work out some formulas in a workbook. This book is shared by people who have little or no knowledge at all of Excel. They are required to input data but sometimes, when an error is made, a formula is accidentally deleted in one of the columns. Is there any way I can protect parts of the worksheet and not others? -- Lynne Mawson Manchester Perhaps a trip to the help index for PROTECTION could be of assistance -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com "Lynne Mawson" <LynneMaws...

Does anybody know how to write an array formula that includes a wildcar character such as ? or * I'm using a simple SUM(IF) array. =SUM(IF((C6:C25="*Wiscons*"),E6:E25,0)) Ctrl+Shift+Ente -- Scorpvi ----------------------------------------------------------------------- Scorpvin's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2767 View this thread: http://www.excelforum.com/showthread.php?threadid=47213 Scorpvin, try the following: =SUM(IF(ISNUMBER(FIND("Wiscons", C6:C25)), E6:E25, 0)) as array formula of course. HTH Kostis Vezerides ...

I have a set of data on one sheet that is arranged with related types of data every 10 rows. So my swim data is in cells A1 1500 yds A11 1000 yds A21 2000 yds A31 3500 yds They are always a certain length apart. what I am trying to do on another sheet is to reference this data in one group. So that I can pull in this data so that it they are adjacent to each other. So basically on the next sheet I want it to be: In cell C1 I want =A1 In cell C2 I want =A11 In cell C4 I want =A21 etc... Is there an easy way to copy get this without having to link each cell individually. I h...

can i hide the formula? i want if i have a formula in A1= sum(a2:a10) i want to see the user is "hyper" in formula not =sum(a2:a10) tnx in advance godspeed :cool: -- xtrmhyper ------------------------------------------------------------------------ xtrmhyper's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=23851 View this thread: http://www.excelforum.com/showthread.php?threadid=382721 If you want the user to see "hyper", why not just type Hyper? What's the point of the sum formula if you can't see its result? ******************...

With regards to an 'IF' formula, how do i get it to reconise whole numbers only. For example, if the result was either 1,2,3,4,5,6.... the answer would be true but if the result was either 1.5,2.7,3.2 etc and not a whole number, then the answer would be false. i can get it to recognise a single whole number but not multiple whole numbers. I know there is a very simple answer to this but i am new to this game. Many Thanks James -- jdmagoo ------------------------------------------------------------------------ jdmagoo's Profile: http://www.excelforum.com/member.php?action=get...

find the formula for converting Binary to Hexadicimal BIN2HEX worksheet function. see help "Teraawete Tekena" <Teraawete Tekena@discussions.microsoft.com> wrote in message news:7AC160AA-6941-4CD2-98F5-67F27FDF2739@microsoft.com... > > find the formula for converting Binary to Hexadicimal ...

Anybody know a formula that will count only text in a range of cells? I did a counta but when I delete content in the blank cells the cells number changes? Thanks in Advance. =COUNTIF(A1:A4,"*") I guess I understand your question. Just list your text in the cell and do a countif function. Hope that helpe -- Message posted from http://www.ExcelForum.com Use this =COUNTIF(A1:A15,">=a") Count Range is A1:A15 amd the 2 arg MUST be in QUOTES. Numbers in this range won't be counted but Caps and lower case ascii characters will. >-----Original Message---...

The results of a Vlookup will be #N/A in cells that do not find a match. I saw someone write a forumula that would sum the column while overlooking the #N/A cells but I don't remember how it was written. Any help will be greatly appreciated. Thank you You could have a formula like: =if(isna(lookup(a,range,1)),0,lookup(a,range,1)) It basically states that if you would get a #N/A result, then show 0, which would not affect a SUM. Andr� "Jean" <jepperson@zebco.com> wrote in message news:096801c34ad7$77c9e510$3501280a@phx.gbl... > The results of a Vlookup w...

I am trying to build a spreadsheet that calculates cashflow forecasts for contingency based fee billing. Basically a completed engagement would be capitalized upon over "N" years and more importantly billed in quarters. If I finish an engagement in month one, I will see my first cheque in month 2 and the rest of the cheques in months 5/8/11/14/17/20/23 based on a two year agreement, but some are 1 year and some are 3 year. The problem is I want to plug in a variable number of engagements (at variable amounts and durations) for each month and then have the spreadsheet calculate the ...

My formula that i copy isnt updating. so if i paste f3*4 i get 5 if i paste the forum f4*4 i still get 5. excel isnt getting it that i have a different number in f3 than in f4. thanks for any help -- chasecompany2 ------------------------------------------------------------------------ chasecompany2's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33687 View this thread: http://www.excelforum.com/showthread.php?threadid=534612 calculation mode? -- Don Guillett SalesAid Software dguillett1@austin.rr.com "chasecompany2" <chasecompany2.26kjnb_1...

I'm new to Excel. I have a huge inventory spreadsheet where I need to change a column to reflect the following. "P01-02-C-1" should become "P102C1" (remove 0 and dashes) "V1-25-F-2E" should become "125F2E" (remove V and dashes) HELP!! highlight the column header (ie C)>edit>replace> - >> blank>>>> -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett@gmail.com "jackierae17" <jackierae17@discussions.microsoft.com> wrote in message news:CC3C8AF8-DBEC-444A-99AE-2AE62CBCD18...

I know this is simple but... how can I get my on-screen button which ha a macro assigned to it, to put a formula in a cell. . In other words, I made a "Reset" button that sets many cells to "0" others to certain numbers (like 450 or 50) and two others need to hav a formula. When I set the code in the macro to: Range("B53").Select ActiveCell.FormulaR1C1 = "b3*.0035" It puts the above formula in the cell instead of computing the answer. All help is appreciated. Please help oh mighty Excell Gods -- Message posted from http://www.ExcelForum.com ...

I want to create a formula to allow me to enter a # into a cell that will display a corresponding months name in that cell. In doing an IF statement I have been getting a cricular error, I assume because i'm creating the formula IN the refrence cell, or Excel can't find the project or library. Either way I'm sure I'm not creating the formula correctly. Example: I want to enter 01 for January, 02 for February and have the corresponding mont displayed in the cell I'm creating the formula in. Is this possibe if written in the same cell? Sounds pretty simple but I can't get...

I'm using the following formula to add up the number of times I have text in a cell. However, whenever I extend the range I get 0. =SUM(IF(ISTEXT(C28:L28),1,0)) For example, if I extend the range to M28 I get 0. If you're able to figure out this question, I would like to add .5 to the total. Any suggestions or help would be greatly appreciated. Thank you in advance, Dick =SUMPRODUCT(--(ISTEXT(C28:M28)))*0.5 is a better way of doing it and it can be entered normally but it wouldn't explain the zero result, works fine for me when testing -- Regards, Peo Sjoblom ...

I neeed to merge 16000 rows of data with some duplicate vales. Poor record keeping lead to two lists and each was updated independantly if at all. Some orders show up one list and not the other so I can't just sort or do a dup search. I'm trying to recreate this data and track the status of all orders for the past 12 months. When orders were shipped out in parts the same order number was used and this has been a nightmare trying to sort the duplicates and match the dates. I need a formula for F that returns the current status based on the order number and date. I tried a...

I need the formula to multiply by 3 diferent rates base on the following assumptions if a<10,000,a*0.08,if a>10001,a*0.06, if a>20001,a*0.04. can anyone help ? I sure hope that's not a Sales Commssion scale.......... Vaya con Dios, Chuck, CABGx3 "clemente821@msn.com" wrote: > I need the formula to multiply by 3 diferent rates base on the following > assumptions if a<10,000,a*0.08,if a>10001,a*0.06, if a>20001,a*0.04. can > anyone help ? =IF(A1<10000,A1*0.08,IF( A1>20001,A1*0.04,A1*0.06)) Laura Cook "clemente821@msn.com" &...

i am trying to figure out how to set up a formula to quantify th variance between two ranked lists. column "c" is one list; column "d" is another. In column "e" i wan the variance between columns "c" and "d". in column "f", i want th cumulative variance, basically a running total of the variance betwee columns "c" and "d". it would work something like this. Column: "c" "d" "e" "f" 1 1 0 0 2 3 (1) (1) 3 5 (2...

how do I write a formula that will allow me to input dollar amount in c1 and then have excel divide that amount by 13.57 and convert the result into days then also add that figure to a date already input into di and so on down the columns On the desired cell type this formula and copy it down that column =int(c1/13.57)+d1 "wolfmasterr" <wolfmasterr@discussions.microsoft.com> wrote in message news:E278B0B3-E1A2-417A-A4A3-BCE67F91CBB0@microsoft.com... > how do I write a formula that will allow me to input dollar amount in c1 > and > then have excel divide tha...

HELP PLEASE. The formulas in my excel 2007 stopped working. When I opened it today, they just stopped. I enter information into cells and the calculations do not work. Its just blank. I checked excel options to see if calculations were set to automatic and they were. I use this worksheet everyday at work and desperately need it fixed. Anybody know what to do? See your other post. -- Jim Cone Portland, Oregon USA "Edward" <Edward@discussions.microsoft.com> wrote in message HELP PLEASE. The formulas in my excel 2007 stopped working. When I opened it today, they just...

Hi all, I have an excel worksheet with a little over 4000 rows.. Column A is a customer number and column B stores the amount they have spent in the last month A customer numeber may appear many times in consecutive order. What I need is to sum up the amount each customer spent and start again at 0 when a new customer numeber is encountered Thanks in advance "Brendan" <brendanboland@eircom.net> wrote in message news:0ad001c3460e$e290e920$a501280a@phx.gbl... > Hi all, > > I have an excel worksheet with a little over 4000 rows.. > Column A is a customer numbe...

I am certain there is a really simple way of doing this and I am just too stupid to figure it out... I just want to have Row 1 Column B show a start time I manually enter (say 9:15PM), then be able to enter 10 (ten minutes) in row 2 column A to show a value of 9:25PM in row 2 column B. Row 2 Column B has time value (9:20PM) Row 2 Column A has minutes allowed (20) In other words, add B2 and A3 and show them as a new time in B3. Any takers??? Hi, if you type just 10 on a2 the formula should be =b1+time(0;a2;0) if you type 00:00 is just b1+a2 hth regards from Brazil Marcelo "mar...

I am using Outlook 2007 and can't see my contacts when I try to compose mail, although they are present in a folder under Personal Folders. There is a help item with this exact topic, but when I follow the suggested steps I can't fix the issue. The help topic first suggests checking the box "Show this folder as an e-mail Address Book" but this is greyed out. It then says that if it is greyed out to go to Tools -> Account Settings -> Address Book and if under "Name" "Outlook Address Book" appears (which i does on my system) to go to ...

Hi All, I want to get across the following: I have dropdown list in colum A and in column b some information. In coulum c I want to say (if the word in column a equals "fortnightly", then multiply B and another cell) For some reason it is not allowing me to put an if sum using the drop down list. Can someone help? Thanks! On Oct 3, 3:42=A0pm, Excel_Oz <naomir...@gmail.com> wrote: > Hi All, > > I want to get across the following: > > I have dropdown list in colum A and in column b some information. In > coulum c I want to say (if the word in column a equa...