Counting Data in Excel
Hi!
Try this:
=SUMPRODUCT(--(B2:B57="DLA"),--(D2:D57=1))
Better to use cells to hold the criteria:
A1 = DLA
A2 = 1
=SUMPRODUCT(--(B2:B57=A1),--(D2:D57=A2))
Biff
"Marilyn" wrote in message
...
I'm trying to count data based on the value in 2 columns. I'm using the
following formula =COUNTIF(B2:B57,"DLA")--COUNTIF(D2:D57,1) but it is
giving
me the wrong count. Is there a way I can make this work?
Thanks,
|