Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kenny
 
Posts: n/a
Default How do I build a excel sheet that counts item in an inventory

any help would be greatly appricaited. thank you...
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
 
Posts: n/a
Default 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...



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul B
 
Posts: n/a
Default 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...



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - automatic information from one sheet to another?? Kathrine J Wathne Excel Discussion (Misc queries) 2 August 30th 05 09:49 AM
Copy Name and email address from web sites to excel sheet Philip Excel Discussion (Misc queries) 0 August 10th 05 11:02 AM
Updating excel sheet with selected data from another sheet in the same file gsnivas Excel Worksheet Functions 1 August 4th 05 09:55 AM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Hyperlink to specific sheet in Excel Web File jd17 Links and Linking in Excel 0 December 8th 04 09:03 PM


All times are GMT +1. The time now is 04:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"