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