I have built a summary report in Excel that uses primarily 'SUMIF' formulas
to calculate totals by customer from another sheet in the workbook containing
the source data. In one of my report columns, I actually need to pull the
MAX value from the source data---but it needs to be specific to each customer
in my summary report. (I'm thinking of a "MAXIF" type function) Is there
any way I can do this without converting my report to a Pivot Table, which I
really don't want to do??

Something like

=MAX(IF(rng1="Customer",rng2))

as an array formula, so commit with Ctrl-SHift-Enter

--

HTH

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


"JDay01" wrote in message
...
I have built a summary report in Excel that uses primarily 'SUMIF'
formulas
to calculate totals by customer from another sheet in the workbook
containing
the source data. In one of my report columns, I actually need to pull the
MAX value from the source data---but it needs to be specific to each
customer
in my summary report. (I'm thinking of a "MAXIF" type function) Is
there
any way I can do this without converting my report to a Pivot Table, which
I
really don't want to do??

Try this, entered with CTRL-Shift-Enter

=MAX(--(C2:C25=cust)*A2:A25)

"JDay01" wrote:

I have built a summary report in Excel that uses primarily 'SUMIF' formulas
to calculate totals by customer from another sheet in the workbook containing
the source data. In one of my report columns, I actually need to pull the
MAX value from the source data---but it needs to be specific to each customer
in my summary report. (I'm thinking of a "MAXIF" type function) Is there
any way I can do this without converting my report to a Pivot Table, which I
really don't want to do??