Hello again..

I have been working with the formula =SUMPRODUCT(--($B$35:$B$68>=LEFT(H$3,2)*1)*($B$35:$B$68<=RIGHT(H$3,2)*1)*($E$35:$E$68=$E4)) which works perfect for my purpose to collate stat data. I want to use this formula but add another specific so that it will apply only if column another column (D35:D67) has "fc" in a cell. Is this possible and what is the function that would make this happen. Ive tried for days using differnt function without success.

I would appreciate any advice or assistance with this issue

Kind regards

Meck
excelforum 01-12-2012 Formal complaints column.xls