Ask Experts Questions for FREE Help !
Ask
    Jill622's Avatar
    Jill622 Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Feb 11, 2008, 12:01 PM
    Two conditional IF statement using Month function
    I am trying to write a two conditional IF statement that sums up values in column C if for example column A = January and column B = category x. The result would be January sales for category x after querying a large spreadsheet of sales data.

    Right now I'm using the following formula:
    =SUMPRODUCT(--(MONTH('raw data'!$B$2:$B$18266= 2),--(('raw data'!$H$2:$H$18266) ="Acme"),'raw data'!$O$2:$O$18266)

    For some reason, the month function doesn't seem to be working as I get the same answer regardless of what month I'm looking for. Theoretically, if the month is "2" it should return a 1, if the category is "Acme" it should return a 1 which would then multiply 1x1xraw data sales value. If either of the first two conditions are not true, they would give a zero which would return a zero for the full product.

    Any thoughts on why the month function isn't working? Maybe the array?

    Thanks!
    ebaines's Avatar
    ebaines Posts: 12,131, Reputation: 1307
    Expert
    		  
    #2

    Feb 11, 2008, 02:36 PM
    You are missing a close parenthesis in the first array - should be:

    (--(MONTH('raw data'!$B$2:$B$18266)= 2),

    Other than that, I tried a similar formula in my versoin of excel and it seems to work as intended. My only other suggestion is to try debugging this on a small set of data and see if you get the answer you want.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Multiple-step income statement in good form and retained earnings statement [ 1 Answers ]

Hi I would like someone to check to see if I did this correctly, if I did not then please help. Thanks The Problem is: The following pretax amounts pertain to River Corp. for the year ended December 31, 2008. Sales... $400,000 Operating Expenses... 84,000 Extraordinary gain... 30,000...

Income statement, owners equity statement and balance sheet [ 6 Answers ]

Les Fleurs, a boutique in Paris, France, had the following accounts in its accounting records at December 31, 20X2 (amounts in Euros, denoted as "E") Purchases………………... E250,000 Freight In……………… E8,000 Sales discounts…………. 4,000 Purchase returns…….. 7,000 Inventory Sales…………………. ...

Financial Statement with Balance sheet and income statement [ 1 Answers ]

Here's the problem: The Hobart Company incurred the following transactions during 2003: A. Acquired $50,000 of cash capital from owners B. Paid $10,000 to acquire manufacturing equipment C. Paid $5,000 cash for materials used in production D. Paid $2,000 for wages of production workers...

Conditional discharge [ 6 Answers ]

My friend got conditional discharge ,Will it remain on his record? He is a security guard will he be able to renew his license? Please reply soon.

Prepare income statement and retained earning statement [ 1 Answers ]

The following information was taken from the 2004 financial statement of pharmecutical giant Merck and CO. All dollar amounts are in millions. Retained earnings, January 1, 2004 34,142.0 Materials and production expense 4,959.8 Marketing and administrative expense 7,346.3 Dividends 3,329.1...

View more questions Search