Countif Formula with 2 calculations
 

Please help, I have a spreadsheet where l want to do a
count if calculation...

I want to calculate a category, which have for example A,
B, C in it and then l want to calculate the number of
times it has appeared as Overdue or Future which has been
worked out from another calculation. I am trying the
following calculation...

=COUNTIF('Outlook Tasks'!G2:G885,"A")=COUNTIF('Outlook
Tasks'!I2:I885,"OVERDUE")

I am getting "False" back....Please help, l am going
mental trying to work this out.


Thank you,


Belinda

You typed = in the middle of your formula.

I think you meant +.



Belinda wrote:

Please help, I have a spreadsheet where l want to do a
count if calculation...

I want to calculate a category, which have for example A,
B, C in it and then l want to calculate the number of
times it has appeared as Overdue or Future which has been
worked out from another calculation. I am trying the
following calculation...

=COUNTIF('Outlook Tasks'!G2:G885,"A")=COUNTIF('Outlook
Tasks'!I2:I885,"OVERDUE")

I am getting "False" back....Please help, l am going
mental trying to work this out.

Thank you,

Belinda

--

Dave Peterson

I suspect this will not give the desired result,,,the sum of the two
sumif will give you the number of times "A" shows up in column G + the
number of time "OVERDUE" shows up in column I. I think you were
looking for the number of times item "A" was overdue, if so

=sumproduct(('Outlook Tasks'!G2:G885="A")*('Outlook
Tasks'!I2:I885="OVERDUE")*1)


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=320491

sorry, l didn't put in my email address...please email me
directly.


Thank you,


Belinda
-----Original Message-----
Please help, I have a spreadsheet where l want to do a
count if calculation...

I want to calculate a category, which have for example A,
B, C in it and then l want to calculate the number of
times it has appeared as Overdue or Future which has been
worked out from another calculation. I am trying the
following calculation...

=COUNTIF('Outlook Tasks'!G2:G885,"A")=COUNTIF('Outlook
Tasks'!I2:I885,"OVERDUE")

I am getting "False" back....Please help, l am going
mental trying to work this out.


Thank you,


Belinda
.

Ahh. I missed the point of the question.

=SUMPRODUCT(--('Outlook Tasks'!G2:G885="A"),
--('Outlook Tasks'!I2:I885="OVERDUE")
+('Outlook Tasks'!I2:I885="Future"))

To include "Future"



duane wrote:

I suspect this will not give the desired result,,,the sum of the two
sumif will give you the number of times "A" shows up in column G + the
number of time "OVERDUE" shows up in column I. I think you were
looking for the number of times item "A" was overdue, if so

=sumproduct(('Outlook Tasks'!G2:G885="A")*('Outlook
Tasks'!I2:I885="OVERDUE")*1)

--
duane

------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=320491

--

Dave Peterson

Or this one:

=SUMPRODUCT(('Outlook Tasks'!G2:G885="A")
*('Outlook Tasks'!I2:I885={"OVERDUE","Future"}))

Dave Peterson wrote:

Ahh. I missed the point of the question.

=SUMPRODUCT(--('Outlook Tasks'!G2:G885="A"),
--('Outlook Tasks'!I2:I885="OVERDUE")
+('Outlook Tasks'!I2:I885="Future"))

To include "Future"

duane wrote:

I suspect this will not give the desired result,,,the sum of the two
sumif will give you the number of times "A" shows up in column G + the
number of time "OVERDUE" shows up in column I. I think you were
looking for the number of times item "A" was overdue, if so

=sumproduct(('Outlook Tasks'!G2:G885="A")*('Outlook
Tasks'!I2:I885="OVERDUE")*1)

--
duane

------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=320491

--

Dave Peterson

--

Dave Peterson

Nope, still getting an error.

-----Original Message-----
You typed = in the middle of your formula.

I think you meant +.



Belinda wrote:

Please help, I have a spreadsheet where l want to do a
count if calculation...

I want to calculate a category, which have for example
A,
B, C in it and then l want to calculate the number of
times it has appeared as Overdue or Future which has
been
worked out from another calculation. I am trying the
following calculation...

=COUNTIF('Outlook Tasks'!G2:G885,"A")=COUNTIF('Outlook
Tasks'!I2:I885,"OVERDUE")

I am getting "False" back....Please help, l am going
mental trying to work this out.

Thank you,

Belinda

--

Dave Peterson
.

Did you try all the suggestions?

Belinda wrote:

Nope, still getting an error.

-----Original Message-----
You typed = in the middle of your formula.

I think you meant +.



Belinda wrote:

Please help, I have a spreadsheet where l want to do a
count if calculation...

I want to calculate a category, which have for example
A,
B, C in it and then l want to calculate the number of
times it has appeared as Overdue or Future which has
been
worked out from another calculation. I am trying the
following calculation...

=COUNTIF('Outlook Tasks'!G2:G885,"A")=COUNTIF('Outlook
Tasks'!I2:I885,"OVERDUE")

I am getting "False" back....Please help, l am going
mental trying to work this out.

Thank you,

Belinda

--

Dave Peterson
.


--

Dave Peterson