Hi,
I have 5 columns of data (please see attachment). What I would really
like to do is to only add up the data in the 4 columns that are between
2 dates. For example, I would like to specify that all numbers in the
'calls made' column that are between 14/09/05 and 16/09/05 in the 'date
changed' column are added up but leaving out all other data that does
not fall between these two dates.
I hope this is clear and I would be extremely grateful if someone could
steer me in the right direction!
Many many many thanks
Justin
+-------------------------------------------------------------------+
|Filename: screen1.gif |
|Download:
http://www.excelforum.com/attachment.php?postid=3806 |
+-------------------------------------------------------------------+
--
justinelliott
------------------------------------------------------------------------
justinelliott's Profile:
http://www.excelforum.com/member.php...o&userid=27176
View this thread:
http://www.excelforum.com/showthread...hreadid=466817