General
in [Excel]
|
Sumproduct;3 criteria Hello, I need a formula that will sum the dollar value of a column if the entries meet 3 seperate criteria. The current formula I have (that returns a #NUM error) is: =SUMPRODUCT(('May YTD Data'!$K:$K="New Customer"),('May YTD Data'!$AB:$AB=B6),('May YTD Data'!$D:$D>4/30/2010),('May YTD Data'!$D:$D<6/1/2... 4 Jun 2010 17:00
Vlookup and Hlookup help I have a situation where I need to lookup Product A but then lookup Company A in a column that changes. vlookup("Product A",A1:T25,hlookup("Company A",A1:T25,0)) but can't seem to get this to work. The vlookup area has Product A listed 5 times but Company A (horizontally is only listed 1 time). I hope this... 4 Jun 2010 12:34
Delete rows with Symbols I receive files from China that always has foreign characters, which sometimes translate to symbols or ASCII characters in it. I would like to be able to delete any row that contains any of these ASCII/symbols in it. Help please! Thanks!! ... 4 Jun 2010 11:28
hightlight cells i need to hightlight a cell when i have one birthday in my list ... 4 Jun 2010 11:28
SUMIFS My SUMIFS formula was "accepted" but the result is 0.0 even though there are numbers to add. What can the problem be? The formula is =SUMIFS(AN3:AN997,C3:C997,"ARC",D3:D997,"EOC") I want the total form column AN when column C is ARC and when column D is EOC ... 4 Jun 2010 18:07
Keep Font format when importing excel into Access We have an excel spreadsheet that is updated by changing select text to red and highlighting in a text cell. So there are only certain strings where the format is changed and the rest stays as the default format. This select formatting does not carry over when it is imported into an Access database. Is ther... 4 Jun 2010 15:54
Pick list width changes by itself...why? I have some columns with the width 4. Sometimes the validation pick list is wide like 40 and sometimes it is only as wide as the column. I already know there's code to temp make the column wider when you click on it. But this behaviour of the pick list sometimes appearing much wider than the column makes me thi... 4 Jun 2010 10:21
Formatting Dates from Text to Numbers I receive data daily with dates in the following formats: dd/mm/yyyy, d/m/yyyy,d/mm/yyyyy, or dd/m/yyyy... The values actually are text vs. numbers. Regardless I use text to columns, to separate the values into three columns. Then I use =date(year, month, day), actually =date(a2,b2,c2) to populate the d... 4 Jun 2010 10:21
Sum a range based on a column In column A I have subaccount numbers which may repeat. In columns B thru F, there are amounts that I need to sum if they meet the specific criteria of what is in column A. How do I sum B:F if column A is 74503? Thanks in advance. A B C D E F 74503 10 2 ... 4 Jun 2010 10:21 |