Worksheet Functions - Page 108

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Thread / Thread Starter	Last Post	Replies	Views
Adding amounts that fall within a range by pdgaustintexas I need a formula that will add amounts in Column B if it falls within certain range in Column C. If Column C is greater than 725, then add amount in Column B...	January 21st, 2006 01:55 PM by Don Guillett	6	120
Adding an accumulator for multiple cells by jrambo63 From this group I learned to add a single cell accumulator using the code on http://www.mcgimpsey.com/excel=AD/accumulator.html Private Sub...	May 26th, 2005 05:50 PM by JE McGimpsey	3	119
Adding an additional forumula to my SUMPRODUCT formula by Mark D Good afternoon everyone I am sure this is pretty simple but everything I am trying isn't working, Hoping someone can help I have the following formula...	May 27th, 2010 09:53 PM by Jacob Skaria	1	262
Adding an aditional forumla to this one by Mark D Hi Guys Had some great help yesterday on here from Bob Phillips (Thanks again Bob) I know have the following formula that works...	April 1st, 2010 04:57 PM by Mark D	4	110
adding an amount to each cell by mark I have a spreadsheet that already has numbers in it. I want to add .40 to each cell at the same time. Can this be done? Thanks -- mark	August 4th, 2008 10:47 PM by T. Valko	3	83
Adding an AND Statement to COUNTIF by Kenton_SJ I want to count how many times a salesman's name comes up in a list. I would like to be able to break it up by year, so the COUNTIF will filter through the...	June 17th, 2005 11:59 PM by Bob Phillips	2	103
Adding an AP to a worksheet automatically by Dave Hi all, I've been trying to achieve the above now for a couple of weeks and I've got nowhere. Please could someone help me? I have a list of transactions in...	November 7th, 2006 09:59 PM by Dave	2	54
Adding an Audible Alert To A Worksheet by carl I am monitoring stocks. I have a column of formulas that returns Yes or No. In almost all cases, the cell value is No. Once every few days, a value can switch...	July 5th, 2005 08:27 PM by carl	0	99
Adding an image to a cell by Zack How can I get an image to appear when a particular cell is clicked on, from instance, I have a product name "Furnace" and when you click on that cell, a...	January 14th, 2009 06:57 PM by Niek Otten	1	58
Adding an Offset to a Column Value by SidBord I often have a formula executing on one sheet referring to data on another sheet. My problem is that, while I can determine the column letter of one column, I...	April 17th, 2004 07:21 PM by	2	811
Adding an ongoing value to an Average by biggcheese I am running a yearly total for a weekly average on a new worksheet every week as...	August 22nd, 2005 05:43 AM by agarwaldvk	3	75
Adding an OR to SUM(IF.... by JustMe602 =SUM(IF(MONTH($A7)=MONTH(DTd)IF(DTam="M",1,0),DTeb),IF(MONTH($A7)=MONTH(DTd)IF(DTam="A",1,0),DTeb)) I would like to combine if possible to read something...	January 5th, 2006 08:07 PM by Biff	3	122
Adding an overall percentage to price list by Toni Hi, I have tables of price lists given to us by our supplier all in Excel format. Our supplier has just advised of a 2% price increase on all their...	June 15th, 2004 05:01 AM by JE McGimpsey	2	209
Adding and Deleting rows - update formulas help needed. by bperks I have built an evaluation scorecard and want to be able to allow others to use it without always having to do it for them as they know nothing about formulas....	May 31st, 2006 08:30 PM by bj	1	58
adding and divideing by a the number of cells! by nerdman Hey guys im making an excell document, i want to make a function that does this : adds all the filled out cells(not the empty ones) and divides them by their...	December 14th, 2005 06:20 PM by Louise	7	93
Adding and ISERROR to the following (large Formula) by Joe Cook =IF(AND(INT(E8)=INT(G8),NOT(ISNA(MATCH(INT (E8),HOLIDAYLIST,0)))),0,ABS(IF(INT(E8)=INT(G8),ROUND(24* (G8-E8),2), (24(DAYEND-DAYSTART) (MAX(NETWORKDAYS(E8+1,G8...	May 23rd, 2004 01:20 PM by Joe Cook	9	295
Adding and multiplying by suroora I have Excel 2002. How do I add A1 + B1 * C1? When I put the formula in, it mulitplied A1 by C1 and added B1. Thanks, Suroor	March 17th, 2009 02:57 PM by suroora	2	54
Adding and Naming Multiple Worksheets by Byron I am looking for an efficient way to add and name multiple worksheets. I have a sheet with multiple categories which I must then split into new worksheets. ...	September 8th, 2005 02:52 AM by Byron	6	277
adding and subracting credits by dmedina Hi I have a total of debits and I also have some credits. What formula do I use in order to have excel add the debits but not subtract the credits which...	November 30th, 2007 09:42 PM by dmedina	2	95
adding and subtracting sums by Neal How do I added Sums. ie I have a cell 1 has the formula; =sum (a1:a5). cell 2 has the formula =sum (b1:b5). I want to subtract cell 2 from cell1, but when I...	September 12th, 2004 09:41 PM by Myrna Larson	2	175

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed