ABS Function

Posted by Andonny on June 03, 2001 3:36 AM

Hi,
I have the array below but I need to incorperate the ABS Function in Column D. Any suggestions on how I do that. I sometimes have positive and negative in C and it should count as a duplicate.
=SUM(($B$10:$B$100=B11)*($C$10:$C$100=C11)*($D$10:$D$100=D11))

Thanks a million
Andonny

Posted by Aladin Akyurek on June 03, 2001 4:33 AM

=SUM(($B$10:$B$100=B11)*($C$10:$C$100=C11)*(ABS($D$10:$D$100)=D11))

Aladin

Posted by Andonny on June 03, 2001 5:05 AM

Hi Aladin,
Thank you very much for your reply. I tried it but for some reason I get #VALUE!
Would you have an idea why.
Thanks
Andonny

Posted by Aladin Akyurek on June 03, 2001 5:41 AM

Would you post about 10 rows of data where you have also neg values along with criteria? In order to do so, activate an empty cell, type =, select 10 rows of cells from B, C, and D, and then hit control+shift+enter. Go to the formula bar, select the formula you just entered. Hit F9. You'll get an array. Copy that array and post it in the follow up.

Aladin

Posted by Andonny on June 03, 2001 6:06 AM

Hi Aladin,
Thanks a lot for your help. I found the problem. I had a letter in one of the cells in C column.

Take care
Andonny