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
|