View Single Post
  #8   Report Post  
Belinda
 
Posts: n/a
Default

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
.