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

I was curious as to what a "Sconce" was and according to
http://en.wikipedia.org/wiki/Sconce
<Wiki
Sconce (fortification), a military fortification
Sconce (light fixture)
Sconcing, imposing a penalty in the form of drink.
</Wiki

I would guess you are dealing with electrical fittings, but the 3rd option
sounds much more fun, and quite possibly cheaper.

NickHK

"Duste" wrote in message
...
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 08:44 AM.

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"