Excell multiple cell count

[Jeepers]

Hi there- I am what you would call a self taugh user of excell. I am trying to calculate multiple cells.

Example. I want to count the "Y" in G3:G634 and then count cells b3:b354 and c3:c354 only if they both meet certain criteria. Any suggestions? I am not sure how to explain this. Hope it makes sense. Thx

 

[Norie]

Well for your first question a COUNTIF is probably the answer:

=COUNTIF(G3:G634, "Y")

Can you explain your second question further?

BTW you've posted this in the Access forum not the Excel one.

 

[Jeepers]

Well for your first question a COUNTIF is probably the answer:

=COUNTIF(G3:G634, "Y")

Can you explain your second question further?

BTW you've posted this in the Access forum not the Excel one.

Hello and thx for replying. Figures i posted in the wrong forum lol... Story of my life lol Anyway to explain the second part of my question............


I am in payroll and i want the "y" to register only if column B reads a certain week.... week 1 for example but also column C has to read 247

to explain this further let me lay it out for you

Column G is going to be blank of have a Y

Comumn B is going to have numbers ranging from 1-52 for the weeks in the year

Column C is going to have 4 Seperate entries either:
247AM
247PM
248AM
248PM

Now i want column G to register the "y" only if say i am looking for 247 AM reps in week 1 or whatever week i choose

Thx for any help you can give.

 

[Norie]

Darcy

I'm still unclear as to what you want to do.

It sounds to me as though you might want a pivot table or SUMPRODUCT worksheet functions.

I suggest you create a new post in the Excel forum.

You could post a sample of the data you have and the result you require using Colo's HTML Maker?