A Formula required - please!

A

Anthony

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top