Thread: Is there a way?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NickHK NickHK is offline
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