Help on a Complicated Formula

[Guest]

Hi Folks,

Here is the situation. I have a range of cells with drug names in them what
I need is when a date is input into a pecified field I need this to total up
in a different cell but this has to be done by Months. See below.

A1 B1 C1
Drug name Aspirin Paracetamol
02/02/06 03/03/06

Result would be as follows:

Totals Aspirin Paracetamol
Jan 0 0
Feb 1 0

Mar 0 1
Apr
May
etc

There will be other Data entered into columns which contain the date so the
formula can only recognise the date part and add the totals.

Can anyone help???


Thanks


Mark

 

[Guest]

One of the important things in programming is your data base design. It
should be designed so that the data you intend to work with is identifiable
and accessible. If you cannot control how the raw data is formatted, then
you will need to devise a method to transfer that data into your data base in
a consistent manner. It is much easier to work with and manipulate data
items when the same data types have their separate fields, or are at least
consistent in format so that they may be programmatically parsed into
separate fields.

In case you are wondering, I am referring to the statement that the date may
have other data entered it that column.