Cheryl W Wrote:
I want to count the number of times the data in column a =913 AND the
value
in column c is <=999. I only want to count rows in which both
conditions are
true. Countif only allows for one condition so how do I accomplish
this?

Hi Cheryl

Try this type this formula =SUM((A1:A15=913)*(C1:C15=999)) into any
blank cell and enter as an arrayby CTRL/Shift/Enter at the same time

Change the rabges A1:A15 and C1:C15 to suit your data


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=467507