The MAX value of certain type ?

  • Thread starter Thread starter Ayato
  • Start date Start date
A

Ayato

I need to find a formula to caculate the MAX volumes of sales for a certain
vendor.
I have 2 columns "Vendors" & "Sales"

Vendor Sales

x 10000
x 9000
x 15000
y 8500
z 50000
y 9500
y 7500
I need to know the Max sales for vendor "y"

Any idea ?

regards,
Ayato
 
=MAX(IF(vendor_range="y",salse_range,""))

array entered (Ctrl-Shift-Enter)

Jerry
 
Hi Ayato,

=MAX(IF(A1:A7="Y",B1:B7))

Enter above formula as an array formula (with Ctrl + Shif + Enter
 
Back
Top