SUMPRODUCT Returning 0 or wrong totals I have been trying to figure this out for 3 days. I have 2 criterias that need to be met and then I want the total of a column. I am trying to get a total of each region with notes and without notes. Col A is region Col M are notes on accts Col L are dollars A M L 1. ... 5 Mar 2010 15:06 Vlookup or Hlookup does not work Hi, I need a simple formula... seems very diffucult to get In Sheet 1 I have employee names on horizontal line and a lot of numbers in vertical line. In Sheet2, i Have emloyee names on vertical line and in horisontal line i want to set up formula in sheet2 so that it calcualtes total number for each month for ... 5 Mar 2010 09:26 Repeat the macro using different ranges I Apologize - I just posted this to the wrong "group". I will re-post to the "Programming" Group. -- BeSmart ... 5 Mar 2010 05:04 Formula help required I have 3 conditions score divided into 3 parts 50, 75 and 100 % If score in cell = > 27 then -3 If score in cell = >26<36 = -2 If score in cell = >18<27 = -1 My formula =IF(F48>27,"-3",IF(F48>=26<36,"-2",IF(F48<=18<27,"-1"))) If score in cell is > 27 shows false Please advise Cordially Beena K Process An... 5 Mar 2010 05:04 vlookup multiple data Is it possible to have a cell contain two pieces of informaton (e.g., A1 = "Me, You"), a vlookup statement to look for each pece of informaton in that cell (e.g., first "Me", then "You") in another sheet, and display the match in B1? Sheet 1 A1 = "Me, You" B1 = (after vlookup) "Art, Joe" Sheet 2 A1 = "Me... 7 Mar 2010 14:05 Counting sales I have two different datasets. Each with a common identifier. I need a formula that will reference the identifiers in both datasets and count the number of sales a particular agent made. Example. look up this identifier in the other dataset and then give me the value that is 2 columns over from the identifi... 4 Mar 2010 23:39 I need a formula to mark up a product by 200% Hello, i am stupid when it comes to this stuff and frustrate easily!! If their is anyone that can help me i would greatly appreciate it. I have a product and it cost me \$4.50 to produce. I would like to mark it up 200%. What would the function be?? Thanks ... 6 Mar 2010 17:24 Trouble with Pivot Tables & Named Ranges Can I use a dynamic named range setup in one file as a range in pivot tables in another file? When I have the data source file (with the named range) and the pivot report files open, the pivot reports update just fine. But the moment I close the source data, the pivot reports no longer can update and I get a ... 4 Mar 2010 19:12 Vehicle finance spreadsheets I want to be able to set an interest rate, fix a monthly budget, set a baloon/final payment, so that i can see clearly how much depost i've got left against a new ... 5 Mar 2010 00:45 how do I turn the screen off during macro execution There a way to turn off the screen when macros are executing so you can't see the macro running and then turn the screen on to display the results when the macro has completed. I can't figure out how to do this in excel 2007. ... 4 Mar 2010 19:12