LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Is there a way?

Is there a way to add up the number of lines that have writing in them versus
an amount?
For instance I have this spreadsheet and I want to add up how many sconces I
have and every time I add a new one the number updates.
I already have the cost added up just need to know how many equal that final
cost.


Sconces Description cost
4301-ON Living $79.50
372-OB Mirror / living $149.50
431-PN Living $89.50
322-PN Living $149.50
322-PN Living $149.50
1401-SN Bathroom $44.50
2131-SN Living $74.50
1972-PC Living $99.50
8821-NB Bathroom $49.50

 
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



All times are GMT +1. The time now is 10:33 PM.

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

About Us

"It's about Microsoft Excel"