ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I build a excel sheet that counts item in an inventory (https://www.excelbanter.com/excel-worksheet-functions/87678-how-do-i-build-excel-sheet-counts-item-inventory.html)

kenny

How do I build a excel sheet that counts item in an inventory
 
any help would be greatly appricaited. thank you...

Don Guillett

How do I build a excel sheet that counts item in an inventory
 
have a look in help index for COUNT, COUNTA, COUNTIF

--
Don Guillett
SalesAid Software

"kenny" wrote in message
...
any help would be greatly appricaited. thank you...




Paul B

How do I build a excel sheet that counts item in an inventory
 
Kenny, we may need more info if is not what you want, with inventory list in
A1:A25 this will count how many times computer is in the list

=COUNTIF(A1:A25,"computer")
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"kenny" wrote in message
...
any help would be greatly appricaited. thank you...





All times are GMT +1. The time now is 01:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com