View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
vsr_kmb
 
Posts: n/a
Default How to count cells


Hi,
I want to put a summary of Job orders in a table. (Excel (Zip) file
attached)
I am having a problem of total.
I want to make a total of only approved job orders not the all job
orders.
Also if the column contains hot / cold type, I need red and bold for
hot job order of complete row.
Also I want to be counted by job type and entity. For example, in the
total approved 7 permits, CONST entity 3 cold jobs and 1 hot job. how
can i display in the abstract table.
Can anyone help me please.


+-------------------------------------------------------------------+
|Filename: count.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4525 |
+-------------------------------------------------------------------+

--
vsr_kmb
------------------------------------------------------------------------
vsr_kmb's Profile: http://www.excelforum.com/member.php...o&userid=32834
View this thread: http://www.excelforum.com/showthread...hreadid=526634