I am using a workbook to capture quality costs. The worksheet for
capturing the costs contains 20 columns. The actual date of entering
the data appears against each entry.
I want to sum the costs based on certain criteria to a "summary" sheet
from where I can then create graphs. I must be able to summarize the
costs per month on the “summary” sheet.
Example: For January to December, the summary sheet must contain a
column reflecting all the costs of "Internal" defects for "Paint"
against each month in the column.
Some entries might contain empty cells - even the date.
+-------------------------------------------------------------------+
|Filename: Conditional Sum.pdf |
|Download:
http://www.excelforum.com/attachment.php?postid=5130 |
+-------------------------------------------------------------------+
--
Hennie
------------------------------------------------------------------------
Hennie's Profile:
http://www.excelforum.com/member.php...nfo&userid=399
View this thread:
http://www.excelforum.com/showthread...hreadid=566419