Hi,
I'm trying to gather info from a raw data sheet (sheet B), to create a summary sheet (sheet A).
Sheet B contains data in a 7 column/250 row array which is auto filtered.
So far I've managed to use COUNTIF in sheet A where the criteria is one column is sheet B.
But what I would like to do is use COUNTIF with criteria in 2 columns on sheet B?
Thanks in advance,
Craig (xl 2k)
I'm trying to gather info from a raw data sheet (sheet B), to create a summary sheet (sheet A).
Sheet B contains data in a 7 column/250 row array which is auto filtered.
So far I've managed to use COUNTIF in sheet A where the criteria is one column is sheet B.
But what I would like to do is use COUNTIF with criteria in 2 columns on sheet B?
Thanks in advance,
Craig (xl 2k)