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

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
.