Worksheet Functions - Page 55 - OfficeFrustration

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.

		Home » OfficeFrustration forum » Microsoft Excel
Worksheet Functions

Home

Page 55 of 4390

Threads in Forum : Worksheet Functions

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
=COUNTIF across Worksheets by Trevor Shuttleworth How can I turn a formula like: =COUNTIF('Person 1'!$C8,"Off")+COUNTIF('Person 2'!$C8,"Off")+COUNTIF('Person 3'!$C8,"Off")+COUNTIF('Person...	December 8th, 2005 10:58 PM by Trevor Shuttleworth	6	120
=COUNTIF(D4:D29,"0") by mike I need this formula to also count negative numbers	July 18th, 2006 03:48 AM by mike	9	62
=COUNTIF(D4:D29,"0") by mike THE FORMULA THAT I HAVE WILL COUNT ALL POSITIVE #'S IN RANGE AND I KNOW THAT IF I CHANGE MY FORMULA TO READ =COUNTIF(D4:D29,"0") THIS WILL COUNT ALL MY...	July 16th, 2006 03:56 AM by Jerry W. Lewis	2	58
=COUNTIF(range, select items highlighted with specific color) by AA I am trying to create a formula which allows me to create a =COUNIF() count for items on a given column which are highlighted with a particular color i.e....	September 29th, 2009 05:28 PM by AA	2	97
=COUNTIFS(M3:M17,"=MAN",P3:P17,"=2000")+(COUNTIFS( M3:M17,"=LHR",P by Shahzad This formula is workable in Office 2007. Please advise relevant formula in Office 2003. Please forward answer to Regards Shahzad	July 2nd, 2008 08:39 AM by Bob Phillips	1	75
=D3-(D3B#) in which the # is the Row number that the cell is in by samccune* =ROW() will display in that cell, the row number of the cell. but i cant get it to do that in a formula. please refer to the image attached in my previous...	September 22nd, 2004 03:34 AM by samccune	0	136
=DATE(YEAR(P4),MONTH(P4)+1,1) by [email protected] I cant seem to get his one right. How can revise this formula so the cell is blank until data is typed in P4 cell Please advise	January 22nd, 2009 04:37 PM by Dave Peterson	3	64
=DATEDIF by Excel User001 Hello All, I'm using this formula, =DATEDIF(E8,NOW(), "y" ). This returns a 1. I have a spread sheet that determines if an instrument needs to be calibrated...	February 3rd, 2006 04:20 PM by Excel User001	2	98
=DATEVALUE by JR In A1 I have (formatted in text with a list of all months) the month of January is spelled out for this example. In A2 I have the following formula:...	January 31st, 2006 06:10 PM by JR	5	263
=DATEVALUE("7/1/20"&MID(C3,13,2)) creates error by Gary =DATEVALUE("7/1/20"&MID(C3,13,2)) creates error. Automatic Error Checking reports this as a "Text date with 2 digit Years". Formula otherwise works. BTW -...	January 31st, 2006 04:51 PM by Dave Peterson	1	73
=DAYS360 Function by PBR Is there a way to manipulate this function so that it will count a 366 day year? I'm trying to calculate tax prorations and this would certainly be...	August 9th, 2004 04:19 PM by Norman Harker	1	119
=DSUM problems by frustrated! I have a database set up with accounts that are a lot alike, ie: 9C, 9C-S, or 4.12, 4.12 CO, 4.12 CO/LE, so when I set up the =DSUM it looks at the database...	November 4th, 2009 11:00 PM by Peo Sjoblom[_3_]	1	96
=EVALUATE("{ to work in a range of cells by Fin Fang Foom I would like to know if its possible without using any addins or vba. I have a strings of text in a range. Example: Range D2 c,b,z D3 c,b,c D4 w,h,c D5 ...	May 9th, 2007 11:33 PM by Fin Fang Foom	8	96
=EXACT by John I have this forumla =EXACT(AA6,AB6) However, i want it to also look in cell AC6 How?	April 28th, 2004 03:33 AM by Peter Atherton	2	86
=FORMULA(CELL(A1)) ? by Olivier SOW French version bellow ___________________________________ Hi, I have an excel's worksheet with cellule having the same formula. I change often this...	June 30th, 2005 02:24 PM by JE McGimpsey	2	91
=hour formula by Karen I have summed up the total time, e.g 34:40. Needed to split this into 2 cells for hours and minutes. I used the =minute formula which worked fine but the...	May 25th, 2009 02:19 AM by Karen	3	113
=HYPERLINK function and Excel 2003 problem. by [email protected] Hello, I have a worksheet with addresses of the clients, so each row represent one client (Name, Title;Street+no, ZIP, city ...) I would need to put on the...	February 10th, 2006 03:14 PM by [email protected]	1	75
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),QuoteNotes, by sarah =HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),QuoteNotes,0),1)),"Test") What's wrong with this formula? QuoteNotes is a range. I'm attempting to...	February 17th, 2009 02:59 PM by JE McGimpsey	2	77
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),Range ... ? by sarah =HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),QuoteNotes,0),1)),"Test") Why is this working? QuoteNotes is a range. I'm attempting to search for...	February 17th, 2009 02:06 PM by sarah	0	56
=Hyperlink() "Email" by Philippe L. Balmanno Hi, I hope this comes out you may have to expand view to see columns. MS XP Pro Office XP (2002) Excel XP (2002) If you please I need help in determining if...	September 6th, 2004 03:22 PM by Philippe L. Balmanno	1	106

Page 55 of 4390

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is Off HTML code is Off

Forum Jump

All times are GMT +1. The time now is 06:54 PM.