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