countif(and

[sorry1]

i am trying to get a count fo cells for

=countif(and(d4:d60,"jones",j4:j60,"disc"))

 

[David Biddulph]

=sumproduct((d4:d60="jones")*(j4:j60="disc"))
or
=sumproduct(--(d4:d60="jones"),--(j4:j60="disc"))

 

[Mike H]

Try this

=SUMPRODUCT((D460="Jones")*(J4:J60="Disc"))

Mike

 

[sorry1]

IT WORKED. Thanks a bunch.
--
clueless

Try this

=SUMPRODUCT((D460="Jones")*(J4:J60="Disc"))

Mike

 

[Ashish Mathur]

Hi,

Try this array formula (Ctrl+Shift+Enter)

=sum(if((d4:d60="jones")*(j4:j60="disc"),1))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[ShaneDevenshire]

Hi,

If you are using 2007

=COUNTIFS(D460,"Jones",J4:J60,"disc")