Array Formula If - sumif

[Keith L]

I have data in 2 columns,

If there are X's in a cells in Coulmn 1, how do I count the number of cells
on the same lines as the X's in colum 2 that have a specified criteria?

 

[JE McGimpsey]

I have data in 2 columns,

If there are X's in a cells in Coulmn 1, how do I count the number of cells
on the same lines as the X's in colum 2 that have a specified criteria?

Depends on your criterion, but for, say, values in column B less than
one hundred, here's one way:

=SUMPRODUCT(--(A1:A100="X"), --(B1:B100<100), B1:B100)

See

http://www.mcgimpsey.com/excel/doubleneg.html

for more on the "--"s.