inventory counting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do i count the amount of items in a spreadsheet with a specific part
number but not count them if there is an exclude character (x) in a separate
column. I am trying to creat a bill of materials with excludes.

Ex
PN Exclude
001 x
001
002
002 x
002

Total 001 = 1
Total 002 = 2

Thanks,
 
If "PNs" are really text, use:

=SUMPRODUCT(--(A1:A10="001"),--(B1:B10<>"x"))

to count "001". If not, use:

=SUMPRODUCT(--(A1:A10=1),--(B1:B10<>"x"))

HTH
Jason
Atlanta, GA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF / SUMPRODUCT 1
Counting Column 3
find all same numbers in a column without dropdown listing 3
Frequency Question 10
Excel 2007: =DSUM not working as expected 4
Need help with a multiple criteria formula 7
counting more than one criteria in one cell 4
Insert row(s) with vba 3

Back
Top