Functions

SUMIF with NAME RANGE
I'm really struggling with this and I know someone here can help with this formula. I'm not sure what I'm missing. I have 2 worksheets ('Monthly Report'! and 'Summary by Month'!). Both sheets have column $B6:$B137 with Company IDs. I have sales numbers in 2 columns on "Summary by Month'! for each month (D6:E13... 29 Mar 2010 13:39

How do I page break in the middle of a row in Excel?
I would like my document to fill the whole page and not just a 1/2 - 2/3 of the page due to the height of the row. ... 29 Mar 2010 12:30

MSNstockquotes option quotes
Have asked question several times at different forums with no answers. Maybe I'm the only person in the world using this function? Option symbols were recently changed and the old symbols no longer return values from the MSNstockquotes addin. I have seen a couple posts where people have said they have gotten it ... 29 Mar 2010 12:30

count if for blanks with 'or'
Can you use the 'or' with a countif to count blanks -- if so can you tell me how? For example trying to count blanks in a column of data where the range, eg., b1:b100 is blank. ..criteria is something like <A or <1. ... 29 Mar 2010 14:45

Why can't I use the MONTH function within the SUMIFS statement
Thanks Bob - that suggestion worked perfectly! "Bob Phillips" wrote: You just can't, it's daft isn't it, makes SUMIFS more or less pointless IMO. Try this =SUMPRODUCT(--(Category=A2),--(Month(DateOfService)=1),Amount) -- HTH Bob "djhunt77" <djhunt77(a)discussions.microso... 28 Mar 2010 20:06

=vlookup(A1:A835,"bbb",AI7:AL165,C7:C165) giving #value! ????????
Hi I have a problem using vlookup between 2 large spreadsheets. =vlookup(A1:A835,"bbb",AI7:AL165,C7:C165) where a1:a835 ia a list of codes on worksheet 1 "bbb" is the name of the second worksheet, AI7:AL165 is the range in the 2nd worksheet where the code will be found -I then want the text in column C of the r... 29 Mar 2010 06:57

excel
when i type entry, nothing appears in box on spreadsheet.. also the tool bar is gray & most wont work ... 28 Mar 2010 14:35

datevalue returns #value
Hi - I;ve had a look through and cant find a solution to this problem. I have a column that returns a Quarter (of financial year) dependent on the date of an invoice. So an invoice date of 13/04/2009 returns Q1 in the column. I am doing this by converting the date by =datevalue(), and a nested IF formula based... 28 Mar 2010 12:23

how to copy 3 spreadsheets and get the formulas to work
I have 3 workbooks, payments payroll and receipts which are linked by formulas. I want to use them as master copies and use them each year. However when I try to copy and rename them the formulas always refer back to the originals and not to the renamed files. Can you help please? ... 28 Mar 2010 11:17

Conditional Sum - Moving Average
Dear Expert, Want to calculate Moving Average in this format. But Sum is conditional Say B2 to G2 are dates like this. Say B3 to G3 are the prices. A3 is Stock name A2 is empty Can you advise how to make it ...? If I put a 3 in B1 ... Then it can calculate the 3-day moving average in C1. If I put a 7 i... 28 Mar 2010 03:37