A Formula required - please!
 

Hi,

I want to count the number of items ordered each month from my 'data'
worksheet.

in cell C3 is the month of the year, and in cells D3:H3 are spaces for 5
items.
I need a formula that will count up the number of items ordered (with data
present in cells D3:H3) each time the month 'JULY' is entered into cells
C3:C100.
eg

C3 D3 E3 F3 G3 H3
July Apple Pear Banana Apple Orange

result would be 5 as july is shown in cell C3 and 5 items were ordered

or

C3 D3 E3 F3 G3 H3
May Apple Pear Banana Apple Orange

result would be 0 as July is not shown in cell C3

Hope that is clear, and any help apreciated

Hi!

Try this:

=SUMPRODUCT((C3:C100="JULY")*(D3:H100<""))

Biff

"Anthony" wrote in message
...
Hi,

I want to count the number of items ordered each month from my 'data'
worksheet.

in cell C3 is the month of the year, and in cells D3:H3 are spaces for 5
items.
I need a formula that will count up the number of items ordered (with data
present in cells D3:H3) each time the month 'JULY' is entered into cells
C3:C100.
eg

C3 D3 E3 F3 G3 H3
July Apple Pear Banana Apple Orange

result would be 5 as july is shown in cell C3 and 5 items were ordered

or

C3 D3 E3 F3 G3 H3
May Apple Pear Banana Apple Orange

result would be 0 as July is not shown in cell C3

Hope that is clear, and any help apreciated

Biff
thanks - works great !

"Biff" wrote:

Hi!

Try this:

=SUMPRODUCT((C3:C100="JULY")*(D3:H100<""))

Biff

"Anthony" wrote in message
...
Hi,

I want to count the number of items ordered each month from my 'data'
worksheet.

in cell C3 is the month of the year, and in cells D3:H3 are spaces for 5
items.
I need a formula that will count up the number of items ordered (with data
present in cells D3:H3) each time the month 'JULY' is entered into cells
C3:C100.
eg

C3 D3 E3 F3 G3 H3
July Apple Pear Banana Apple Orange

result would be 5 as july is shown in cell C3 and 5 items were ordered

or

C3 D3 E3 F3 G3 H3
May Apple Pear Banana Apple Orange

result would be 0 as July is not shown in cell C3

Hope that is clear, and any help apreciated