Excel Countifs - counting values that meet all criterion from multiple columns

[jlipper]

I'm trying my hand at a countifs function. I want to do a count of all occurrences of the cell value "SLO" in a worksheet (Appears in Column "H"), so long as the date associated with that value is 2014 (Column "E") and the occurence was in the USA (Column "A").



Here's the countifs formula I used:



=COUNTIFS(Data!H2:H200,"=SLO")(Data!E2:E200,">=1/1/2014", Data!E2:E200,"<=12/31/2014")(Data!A2:A200"=USA")



I get an error message -- but as I'm not an expert in this, can't figure out when I'm assuming wrong. Trying to find articles but I think you can use countifs to run scenarios on different columns of data as long as the rows are consistent.



Any thoughts?

 

[Mike H..]

I'm trying my hand at a countifs function. I want to do a count of all occurrences of the cell value "SLO" in a worksheet (Appears in Column "H"), so long as the date associated with that value is 2014 (Column "E") and the occurence was in the USA (Column "A").



Here's the countifs formula I used:



=COUNTIFS(Data!H2:H200,"=SLO")(Data!E2:E200,">=1/1/2014", Data!E2:E200,"<=12/31/2014")(Data!A2:A200"=USA")



I get an error message -- but as I'm not an expert in this, can't figure out when I'm assuming wrong. Trying to find articles but I think you can use countifs to run scenarios on different columns of data as long as the rows are consistent.



Any thoughts?

When cross posting it's polite to NOT waste our time by telling us. I already wasted mine at Microsoft Answers so I won't do so again here.

I'm sure this site will have a policy on this and suspect a longer serving member here will point you to it.


http://answers.microsoft.com/en-us/...function/b615a87a-51f3-4bb1-98b6-4857a7254bd6

Found the policy on cross posting Here

 

[NARAYANK991]

Hi Mike ,

I think we can condone this , since when the OP posted the question in this forum , it was at :

Jul 18, 2014 at 11:42 PM

When the OP did not get any answers from this forum , the same question was posted at the Microsoft Answers forum , at :

Jul 19, 2014 at 05:26 AM

So , unless both of these are somehow at around the same time , it is possible that the OP needed an answer fast , and when none was forthcoming from this forum , posted the same question on another forum , where you have answered and been thanked for it.

Since no one else has answered the question here , I doubt that anyone has wasted their time.

Narayan