View Single Post
  #1   Report Post  
nosaj_enryb
 
Posts: n/a
Default Count formula Help...


All,

I am having some trouble with a count formula in my worksheet.
Example:

I have Cell1-10 in col A populated with the name 'john'
Col B contains different numerical values for Cell 1-10, three of them
being the number 5.

Is there a formula I can use that will give me a count of any cells in
Col A with the value 'John' *AND* any cells in col B with the value
'5'

Help would be much appreciated.

Jason B


--
nosaj_enryb
------------------------------------------------------------------------
nosaj_enryb's Profile: http://www.excelforum.com/member.php...o&userid=28715
View this thread: http://www.excelforum.com/showthread...hreadid=484058