Try

=SUMPRODUCT(--(LEFT(Support!$B1:$B100,6)="bl-565"),--(Support!$G1:$G100,A22)
)

Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range.


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"TISSMOD" wrote in
message ...

Thanks, but I am not able to add any more columns to the worksheet, only
extract data from it(v.important), so I need to filter one column then
by another different column.

example:
column 1 - list of colours
column 2 - list of flowers

count number of red roses
count number of red tulips
count number of blue roses
count number of blue tulips

Please help, I am stumped given the complicated nature of my formulas!


--
TISSMOD
------------------------------------------------------------------------
TISSMOD's Profile:
http://www.excelforum.com/member.php...o&userid=30830
View this thread: http://www.excelforum.com/showthread...hreadid=504931