S
sorry1
i am trying to get a count fo cells for
=countif(and(d4:d60,"jones",j4:j60,"disc"))
=countif(and(d4:d60,"jones",j4:j60,"disc"))
M
Mike H
Try this
=SUMPRODUCT((D4
60="Jones")*(J4:J60="Disc"))
Mike
=SUMPRODUCT((D4
60="Jones")*(J4:J60="Disc"))Mike
S
sorry1
IT WORKED. Thanks a bunch. 
--
clueless
--
clueless
Mike H said:Try this
=SUMPRODUCT((D4
Mike
A
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
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
S
ShaneDevenshire
Hi,
If you are using 2007
=COUNTIFS(D460,"Jones",J4:J60,"disc")
If you are using 2007
=COUNTIFS(D4
60,"Jones",J4:J60,"disc")