View Single Post
#4
September 15th 05, 03:26 PM
 Ellie Posts: n/a

Sorry, also forgot to mention that for the 5th day on the 2nd sheet (16-Sep),
this incorporates the Friday, Saturday and Sunday dates (16-18 Sep) from the
1st sheet.

Ellie

"Paul Sheppard" wrote:

Ellie Wrote:
I have a report over 2 separate sheets in a workbook.

On the first sheet I have my core data, covering approx. 8 columns,
inclusive of date, load number (in columns B and C) and cases (in
column H).
On the second sheet I am currently manually inputting the result of
data
entered into the first sheet.

The data in columns B, C and H are what I manually input into the
second
sheet.

In this 2nd sheet I have column A with the date in the same format as
on the
first worksheet along with column D being the total number of loads for
that
date and column E being the total number of cases also for that date.
Unfortunately on the first worksheet I sometimes have dates where no
data is
available and put this in as "No Issues", but having used COUNTIF
against the
date find that No Issues is being counted, as I obviously have entered
the
date into the first sheet.

e.g. of 2nd sheet in workbook:-
12-Sep
13-Sep
14-Sep
15-Sep
16-Sep
TOTAL 0 0 0
0

As a sample, I had used =COUNTIF(Sheet1!B2:I6,"=12-Sep") against the
Failure
Loads for 12-Sep, which returns the correct number, but unfortunately
when
going for 13-Sep returned 1, even though it was No Issues, so should be
as a
0.

Is there any suggestion to amend the above COUNTIF calculation, to give
me
what I require, or something else to do this for me.

Many thanks.

Ellie

Hi Ellie

Your formula looks ok except you don't need = infront 0f 12-Sep

To help further put a sample of the data from the first sheet

As an alternative, you could just put subtotals on your Data
Subtotals at each change of date

--
Paul Sheppard

------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783