title: Putting a concatenate inside of a count if
body: <p>Alright, I have two excel functions that work. I want to combine them into one.
  Here are the two that work:</p>
  
  <p><code>=COUNTIF('ALL EE Active BEG PERIOD'!$A:$B, 'HC Summary Details'!$A6)</code></p>
  
  <p><code>=CONCATENATE('ALL EE Active BEG PERIOD'!A2," --- ",'ALL EE Active BEG PERIOD'!B2)</code></p>
  
  <p>I thought that maybe I could combine them as follows, but it's not working - where am I going wrong?</p>
  
  <p><code>=COUNTIF(CONCATENATE('ALL EE Active BEG PERIOD'!A2,' --- ','ALL EE Active BEG PERIOD'!B2)),'HC Summary Details'!$A6)</code></p>