IF and THEN formula's

[cw0802]

I'm working on an inventory spreadsheet that uses if and than statements.

This is a list of printers in my company...what i'm trying to do is make is so if the cell is equal to the model number of a specific printer than it adds "1" to the totals. So instead of having to go through and count how many of each model we have, i can just input the model numbers in the "models' column and it'll add up for me.

I've worked on this for hours but can't get it right. Can someone please nudge me in the right direction?

[DonkeyOte]

Perhaps you mean to utilise the COUNTIF function - see XL Help to see if this fits your requirement... eg - assume Printer codes are listed in A and in B1 you enter a particular printer code, you can get the count of how many times that cod appears in Column A in C1 using:

=COUNTIF(A:A,B1)