Summary: If what you want to do is add up the values in column AC associated with a particular value in column D, then you probably want to use the SUMIF funct...
Summary: I am trying to make an if statement that accomplishes something like, If b1=3 then a2=a1 else pick choice from the data validation list(drop down list...
Summary: You're formula worked perectly for the example, thank you. I guess I should have thought about the difference between my example and actual applicatio...
Summary: What the heck..I'll take a guess at what you are trying to do and offer this. Let me know if I guessed correctly. Let's say your data starts in column...
Summary: Hello! I am a mechanical engineer by trade and am working in Excel to manipulate data. I have written macros in the past, but have come to a stumbling...
Summary: I'm a new poster (long time reader). I'm hoping someone can help me with a problem I've encountered. I'm working w/ a pretty elaborate excel spreads...
Summary: Hi, I have an access database with the following fields QuestionNo., Question, AnswerA, AanswerB, AnswerC, AnswerD and Image. Basically Iam developing...
Summary: This has been driving me crazy, as I use the feature a lot. One day I was getting onto Outlook 2007 and my folders were updated. I went to check one...
Summary: Is there a way to make the NETWORKDAYS function work with an IF Statement? Such as: If the NETWORKDAYS from L10 to M10 are <=4, then YES I tried my...
Summary: It might help if you told us what error you are getting. " " is not empty. " " is a space, which is text. A space in I7 or BY7 will result in an #VA...
Summary: Okay i am creating a database for people coutning, I am entering data on a daily basis, with a list for the day such as Monday, Tuesday etc. So at the...
Summary: P.S. Place the quit for reseting the Default Open Mode into an IF condition of course so only when you reset them they are bounced out. This allows t...
Summary: I'm am setting up a spreadsheet to track fuel consumption and hour of heavy equipment. I have conditional formatting set to change the color of a cell...
Summary: I need help adding a range of cells. Each cell in the range was determined by the if statement: =IF(K12>40,K12-40,L12=0. When I add the range L5:L16 I...
Summary: A friendly suggestion... It's helpful to those of us trying to come up with solutions if you include all of your requirements in a single post as oppo...
Summary: I need help adding values associated with equal entries. I am not sure if that makes sense, but here is an example. If I have: Column A Denver Detro...
Summary: i have a workbook some what password protected but need some code to finish it up and was wondering if someone could help??? what i have now is when t...
Summary: I tried "HS" instead of 1 but then i end up with an #VALUE!, I guess because I cannot calculate a value using text or something? The reason I am look...
Summary: As I suspected, you do not have anything set for the value_if_false for the final IF statement. Keep in mind that Excel evaluates the Nested IF's in ...
Summary: Is the data (e.g. 100) static or variable? If it's static, you can use an IF statement: Let's say your dropdown is in E1. In E2, enter: =IF(E1="jeans"...
Summary: I want to see if I can create an IF Statement where if the value ends up with a "divide by zero error #DIV/0! " then it returns a result of zero. ...
Summary: I am getting a pop-up from Outlook asking if I want to allow the email to be sent from another progam. How do I bypass this autimatically the code I ...
Summary: For the morning.... =VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) lookup_value is whatever it is that you are looking up. In my exampl...
Summary: I am trying to create an excel spreadsheet that will calculate hours added and hours lost in a work day. I am a scheduler and I need to track how many...
Summary: Hi, I couldn't think of a way to do all of this with formulas. Maintaining a list of unique referent names on the referent worksheet seems to require...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
