View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default average of non-contiguous range based on criteria

Please remember to quote enough of the message to which you are replying to
make the context of your question clear.

I you are talking about the use of the double unary minus, such as in a
SUMPRODUCT formula, try:
http://www.mcgimpsey.com/excel/formulae/doubleneg.html or
http://xldynamic.com/source/xld.SUMPRODUCT.html#format
--
David Biddulph

"gtslabs" wrote in message
...
Worked Great! - Thank you,
Could you please expalin the use of the -- ?
I have never seen this before.