Nested IF Statements

[sbecker61]

Hello,

I have two columns of data in Excel. One stores a month (i.e. January) and the other stores a type of customer transaction (i.e. Workshop). I am trying to put into a single column all the rows that meet the conditions of "January" and the condition of "Workshop". This is my formula:

=SUM(IF($G$39:$G$67="January",IF($E$39:$E$67="Workshop",1,0),0))

When the formula runs I get a "#VALUE!" error from Excel. What am I doing wrong? I got this formula from the Mr. Excel forum but its not working for me.

I am sure this is an easy one for the Pros here. Thank you in advance.

Steve

 

[Aladin Akyurek]

You need to confirm this formula with control+shift+enter, not just with enter.

 

[Oaktree]

Are you confirming the array formula with CTRL+SHIFT+ENTER? (If you do so correctly, you should see { }s surrounding your formula in the formula bar)

 

[sbecker61]

That was it. Thanks all !!!!!!!!1