Re: sumif absolute values



Can you elaborate, with some example?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"DM" <DM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:49D8F8C5-5356-42E3-BBC6-3C685D8440D0@xxxxxxxxxxxxxxxx
> Is there any way to embed an absolute value function within a sumif
function?
> Is there an array formula that will do this?


.



Relevant Pages

  • Re: very hard deleting rows issue
    ... Your sentiments are well meant: ... >>> HTH ... >>> (remove nothere from the email address if mailing direct) ...
    (microsoft.public.excel.programming)
  • Re: SUMIF where values to be summed are formula
    ... >> HTH ... >> (remove nothere from the email address if mailing direct) ... >>> criteria to be considered in deciding which values are to be added. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Last Saved Date and Time
    ... Did you put the code in ThisWorkbook code module as stated in original ... >> HTH ... >> (remove nothere from the email address if mailing direct) ...
    (microsoft.public.excel.programming)
  • Re: Find last occurance of text in range
    ... > HTH ... > (remove nothere from the email address if mailing direct) ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Extract Numerics only
    ... > 'Similar to Excel's SUBSTITUTE but using VBScript's perl-like regexps ... > HTH ... > (remove nothere from the email address if mailing direct) ...
    (microsoft.public.excel.misc)