Prev: validation
Next: email as pdf print area excel 2007
From: Tmt on 7 May 2010 16:41
Brad,

This brings up more question. This is what I get:
=G125="14521" --------> FALSE
=G125=" 14521" -------> FALSE
=G125="14521 " --------> FALSE
=G125=14521 ----------> TRUE

While another cell will behaves differently:
=G111="10223" --------->TRUE
=G111=" 10223" -------->FALSE
=G111="10223 " -------->FALSE
=G111=10223 ----------->FALSE

I'm confused! Can all cells be formatted to accept one set of rule instead
of tinkering with " " for this cell but not the next?

Tmt

"Tmt" wrote:

> Hello,
>
> I need help solving this formula:
> =SUMPRODUCT(('Q2'!E13:E150="done")*('Q2'!G13:G150="14521"))
>
> where the numbers of "done" items is counted under department 14521. This
> formula works with many departments but skipped department# 14521. But if I
> put a letter, say like 14521S, in my Q2 datasheet and changed this formula to
> =SUMPRODUCT(('Q2'!E13:E150="done")*('Q2'!G13:G150="14521S"))
> then the formula worked again, counting every one that I added the S behind
> those data.
>
> I suspected the cell format and try to format the cells Catergory to
> "General", but that didn't help.
>
> What's wrong? Please help. Thanks.
>
> Tmt
>
>
First  |  Prev  | 
Pages: 1 2
Prev: validation
Next: email as pdf print area excel 2007