View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ckemler ckemler is offline
external usenet poster
 
Posts: 4
Default Sum of absolute values based on criteria

In this example:
Value Criteria
1 a
-2 a
-3 b
4 b
I want to sum the absolute values of criteria a and another sum of absolute
values of criteria b.
I've been researching this and started learning VBA, but I can't get the
answer. Does anybody have any insight?

Thanks,
Chris