Umm I'm confused.
There is a reason that a particular cell is highlighted. Highlighted
cells represent a day that an order is cancelled. I dont want to do
anything to the date column.
What I want is this:
Have a cell that ignores all of column A's highlighed values (in bright
orange) and adds up the rest
A second cell that ignores all *non highlighted* values and only adds
up highlighted values.
Take a look at the following picture to see what I mean
Thanks
+-------------------------------------------------------------------+
|Filename: sample 2.JPG |
|Download:
http://www.excelforum.com/attachment.php?postid=4126 |
+-------------------------------------------------------------------+
--
frustrated
------------------------------------------------------------------------
frustrated's Profile:
http://www.excelforum.com/member.php...o&userid=27778
View this thread:
http://www.excelforum.com/showthread...hreadid=493442