Hi

I have a spreadsheet and I want to add up the number of cells in one column
if the cells in another column equal 1.

I have 800-odd grid references down the page and various columns across -
some are "items" and some are "conditions". I want to know how many grid
references have one particular item that also have one particular condition.
Does that make sense? If anyone can even point me in the right direction
that'd be great.

Thanks