Countif Formula with 2 calculations

[Belinda]

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]

You typed = in the middle of your formula.

I think you meant +.

 

[duane]

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)

 

[Belinda]

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


Thank you,


Belinda

 

[Dave Peterson]

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"

 

[Dave Peterson]

Or this one:

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

 

[Belinda]

Nope, still getting an error.

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

I think you meant +.

 

[Dave Peterson]

Did you try all the suggestions?

Nope, still getting an error.