Excel 2007 : COUNTING the number of "YES" within a Specified Month. Please help me.

[Christopher1990]

Hi All,

I have this formula to count number of incidents within a specified month:

=COUNTIFS(A:A,">=1/1/2012",A:A,"<=1/31/2012")

-----------------------------------------------------

Now, on the following column, I'm trying to find a formula that counts the number of incidents resolved (YES) within that same month.

I've tried using the same formula with the additional argument (I:I,"YES") but it did not work.

Can somebody please help me out?

COUNTIFS, SUMPRODUCTS, DCOUNT..........I could not get any of those to work

I've been trying to figure it out the past few hours, and it's driving me insane

Any help is greatly appreciated. Thank you in advance!

[NBVC]

It should be just an extention of what you have, adding the new condition:

e.g

=COUNTIFS(A:A,">=1/1/2012",A:A,"<=1/31/2012",B:B,"Yes")

where column B is the one to count the "Yes" in.

[Christopher1990]

It should be just an extention of what you have, adding the new condition:

e.g

=COUNTIFS(A:A,">=1/1/2012",A:A,"<=1/31/2012",B:B,"Yes")

where column B is the one to count the "Yes" in.

Hi,

I greatly appreciate your help. I tried adding it as an extension, but unfortunately it does not work

It says that there are too many arguments.

[Christopher1990]

It should be just an extention of what you have, adding the new condition:

e.g

=COUNTIFS(A:A,">=1/1/2012",A:A,"<=1/31/2012",B:B,"Yes")

where column B is the one to count the "Yes" in.

Hi,

I greatly appreciate your help. I tried adding it as an extension, but unfortunately it does not work

It says that there are too many arguments.

[NBVC]

It should not give that error if you are in Excel 2007, using COUNTIFS.

What exactly is the formula as you are testing?

[Christopher1990]

It should not give that error if you are in Excel 2007, using COUNTIFS.

What exactly is the formula as you are testing?

The #incidents formula is:

=COUNTIFS(A:A,">=1/1/2012",A:A,"<=1/31/2012")

the #incidents solved formula I'm trying to use is:

=COUNTIFS(A:A,">=2/1/2012",A:A,"<=2/29/2012",I:I,"YES")


It says there are too many arguments, "the formula is incomplete".

[NBVC]

Very strange.

If the first formula worked, then the 2nd should too... COUNTIFS allows many range/condition combinations...

I copy/pasted your formula to my Excel just to see if there was a unseen quirk, and it worked fine.

You sure you didn't enter extra commas anywhere in your formula in the sheet?

You are welcome to post the workbook so we can double-check it.

[Christopher1990]

Very strange.

If the first formula worked, then the 2nd should too... COUNTIFS allows many range/condition combinations...

I copy/pasted your formula to my Excel just to see if there was a unseen quirk, and it worked fine.

You sure you didn't enter extra commas anywhere in your formula in the sheet?

You are welcome to post the workbook so we can double-check it.

First, I wanted to apologize to you for making a duplicate thread earlier. I'm really sorry about that.

Unfortunately, I cannot post the workbook because it has confidential work data. But I did double-check the formula, and I entered it exactly as I posted it earlier.

=COUNTIFS(A:A,">=2/1/2012",A:A,"<=2/29/2012",I:I,"YES")

Hmmmm....very strange. Are there any other kinds of formulas I can investigate that allow multiple arguments?

[NBVC]

You could try SUMPRODUCT... but you would need to make the ranges smaller, because SUMPRODUCT is not that efficient...

=SUMPRODUCT(--(A1:A100>="2/1/2012"+0),--(A1:A100<="2/29/2012"+0),--(I1:I100="YES"))

but your COUNTIFS formula should not give that error....

See attached simple workbook with your COUNTIFS in cell M1. Does it give a result of 2?

[Jack in the UK]

This not the same question reposted?

Sure i see it before?

jiuk

[Jack in the UK]

opps ok Mods have locked it as dup post see here
http://www.excelforum.com/excel-gene...ate-range.html

Please do not duplicate post it will be some rule and mods get all over your back and your get little help.. just wait and post a BUMP and add anything that can help

Its new years day so many having a beer rather that Excel work for free help so might take time

I mean You well, not having a go

[Christopher1990]

You could try SUMPRODUCT... but you would need to make the ranges smaller, because SUMPRODUCT is not that efficient...

=SUMPRODUCT(--(A1:A100>="2/1/2012"+0),--(A1:A100<="2/29/2012"+0),--(I1:I100="YES"))

but your COUNTIFS formula should not give that error....

See attached simple workbook with your COUNTIFS in cell M1. Does it give a result of 2?

Hi NBVC,

I figured out the issue (although not sure why it was causing problems)

Two of my values within the I:I ranges were incorrectly filled in by other employees. After I fixed the values to a simple YES/NO, the issue went away.

Not sure why it came back as an incorrect formula, but alas, the problem is resolved with the first formula you provided me.

Thanks so much!

opps ok Mods have locked it as dup post see here
http://www.excelforum.com/excel-gene...ate-range.html

Please do not duplicate post it will be some rule and mods get all over your back and your get little help.. just wait and post a BUMP and add anything that can help

Its new years day so many having a beer rather that Excel work for free help so might take time

I mean You well, not having a go

I already apologized to the mod and the thread was closed a while ago. Are you drunk?