ajajmannen Wrote:
Thanks alot it was really a great help....

What I don't understand is why the formula didn't work before you
posted it in a Sample file.....I really did CTRL, SHIFT + ENTER.

But it doesn't matter it do work now :)

This will be a big help for me as this reports needs to be analyzed
every month.

Would you find me to annoying if I asked a followup question regarding
the formula.
I'm now trying to add a AND condition to the IF statement. But it
doesn't work.
the formula looks like this:
=COUNT(1/FREQUENCY(IF((LEFT(Sheet1!N2:N2385;2)="SE")+(LEFT( Sheet1!N2:N2385;3)="INC");AND(Sheet1!T2:T2385="ABD ");IF(Sheet1!A2:A2385<"";Sheet1!A2:A2385));IF((LE FT(Sheet1!N2:N2385;2)="SE")+(LEFT(Sheet1!N2:N2385; 3)="INC");AND(Sheet1!T2:T2385="ABD");IF(Sheet1!A2: A2385<"";Sheet1!A2:A2385))))
I have tried to use CTRL+****+ENTER but it only counts the same number
even thou I change the second AND logical condition to another value.
If it isn't to much to ask please help me find out what the problem
is?

This FORUM is really the best ever for that matter :)


--
ajajmannen
------------------------------------------------------------------------
ajajmannen's Profile: http://www.excelforum.com/member.php...o&userid=34130
View this thread: http://www.excelforum.com/showthread...hreadid=538999