Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Again-revealing the contents of formula | Excel Worksheet Functions | |||
Frequency formula | Excel Worksheet Functions | |||
addition to my date formula...required | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Rate of return required formula | Excel Worksheet Functions |