Hi there,
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('Workshe et'!E:E,I2)+COUNTIF('Worksheet'!E:E,J2)+COUNTIF('W orksheet'!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