H

#### Hilvert Scheper

I can't seem to find any answers here that I need in particular, maybe

someone can help me out here? Sorry if the question's rather long but I'm

trying to explain exactly what I want:

I have a Range of 15 Cells that contain Criteria for my Countif, looking like:

(Cells

F2 G2 H2 I2 J2 K2

AAA BBB CCC DDD EEE FFF

I need to know How many times All these criteria appear in Column E in sheet

"Worksheet", like:

PRODUCT:

AAA

AAA

DDD

EEE

FFF

FFF

ZZZ

(The formula should return a Total of 6)

I am currently using

COUNTIF('Worksheet'!E:E,F2)+COUNTIF('Worksheet'!E:E,G2)+COUNTIF('Worksheet'!E:E,H2)+COUNTIF('Worksheet'!E:E,I2)+COUNTIF('Worksheet'!E:E,J2)+COUNTIF('Worksheet'!E:E,K2)

This works OK, but if I have a range of 15 cells and the column is in

another file, so this way the formula would be a Mile long. Is there a way to

count this in One formula??

Again, Sorry for the Long story, but Many Thanks for Your help!!!

Hilvert Scheper