Hi,
I am sending you copied and pasted data from the real workbook, with a
description of what i need the formula to do.
It's just too hard to explain, the dates on Sheets 1,2 & 3 are never
consecutive as they work a 4 day on/off roster. The item number from
the drop down boxes need to be summarised on the summary sheet with the
total used etc.....the start and end dates are used to count the number
of items used each day (total to be recorded on the summary sheet as
ONE single figure between these dates)....this make sense???
I have used countif and that will count the occurences of the item
number, but not ADD them. Adding them is imperative as each sheet is
actually for different sites and they may use the same item number at
more than one site on the same day.....making better sense???
Thanks
Sandi
+-------------------------------------------------------------------+
|Filename: Testing.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=5113 |
+-------------------------------------------------------------------+
--
rhani111
------------------------------------------------------------------------
rhani111's Profile:
http://www.excelforum.com/member.php...o&userid=19940
View this thread:
http://www.excelforum.com/showthread...hreadid=564594