Your IF statement doesn't seem correct. What is it you're trying to do?
Do you want to count the number of 'AS' in your range of cells if
AS2:AS1551 contains 'White'? If so, try...
=IF(COUNTIF('0 - 2'!AS2:AS1551,"White"),COUNTIF('0 -
2'!AQ2:AQ1551,"*AS*"),"")
Hope this helps!
In article ,
Jeff Cantwell wrote:
Thank you! That may have been what I was missing.
=IF('0 - 2'!AS2:AS1551="White",COUNTIF('0 - 2'!AQ2:AQ1551,"*AS*"),)
I seldom use excel, and am getting a crash course OJT.
|