Hi,

This assumes your data are in columns A through E

=SUMPRODUCT((A1:A10=200948)*(B1:E10="x"))

Mike

"TC" wrote:

Hi, I am using Microsoft 2003. I am trying to add the amount of X's in my
excel and seperate them by the YEAR/WK.

For example I want to know how many X's I have for 200948. For this
function I dont care about the column they are in just how many X's there
are. My sheet is much larger than the one below but it is a sample. I
understand I will have to have a new function per pln_s_yrwk. Any help
would be great!!



yrwk SOC OPC PUR M. PLN
D. PLN
200948 0 0 0 x 0
200951 0 x 0 0 0
200948 0 0 0 x x
200947 0 0 x 0 0
200946 0 0 0 0 x