SUMIF returns no value My SUMIF argument returns no value but when checking fx the Sum_range reflects the correct value, but Formula result is R – =SUMIF(\$A4,'TB SAICMB'!\$A\$4:\$A\$500,'TB SAICMB'!S4) Any help will be appreciated EricB ... 4 Apr 2010 23:41 function to populate a cell where formula is NOT located I'm using excel 2007. I'm looking to have a logical test in one cell that will populate a different cell if true, or a third cell if false. For example, the logical test located in cell A1: If (A2=3, then Cell B2 = "True", then Cell B2="RED") Another variation is to have the value in a cell determine the ... 5 Apr 2010 03:59 Dynamic Table Problem I am using excel 2007. I want to create an invoice where the total number of line items is dynamic. I have created the 'header' section of the invoice with company name, customer name, etc and I have created the 'body' of the invoice using a table. This table has Qty, Description, Unit Cost, and Item Cost. ... 6 Apr 2010 13:04 New to VLOOKUP ...merge addresses? A lot depends on how you have that second sheet set up. To work, first the names on the two sheets must match up exactly with regards to spelling and punctuation. On the second sheet, the names must be in the leftmost column of a 'table' that the VLOOKUP() will reference. For example's sake, I'm going to a... 4 Apr 2010 01:47 total point Sir, How to count total point for cell A1 to J1: A B C D E F G I J 1 4 1 4 3 2 1 1 2 3 if, 1=0 point, 1=5 point, 2=10 point, 4=15 point ... 4 Apr 2010 19:19 MS excell 2007 Data verification list I am attempting to use the list function within data verification for drop down menus. I need a list that is conditional upon the information in another cell. Example: The first cell offers a drop down menu with specific Make of equipment. From what appears in that cell I seek to offer only the Models for t... 3 Apr 2010 20:21 Excell mistake in addition When adding a column of numbers, the sum function failed to accurately sum the numbers. Even summing just 1200, 800, 700, 700 yielded 1900. How do I correct this internal error? ... 3 Apr 2010 14:51 Follow up question about consolidating dups and sums I used the pivot table and it worked like a charm. However, the data is going to be transferred into another program and it needs to be in the same format as the original with headers like: State County Tons Commodity I have played around with the pivot table some, but it is not right. Perhaps a form... 3 Apr 2010 22:32 Data moving 2 I have following code: Sub climate() Dim x As Long, y As Long x = Range("X" & Rows.Count).End(xlUp).Row y = InputBox("enter the row number to paste") Range("A2:BK2" & x).Copy Range("A" & y).PasteSpecial MsgBox "Updated" End Sub I want to cut data of range(A2:BK2 to end row related) and then paste to row nu... 4 Apr 2010 00:43 don't know what function to use If I have in column Z1-Z10 ten company names, then in columns AA-AJ those same company names with the area's they cover in the respective rows. Is there anyway to have an input area in A1 so that excel that will look at that information and be able to pick a company that covers that area AND be able to know an... 5 Apr 2010 15:01