Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to sum
I have a column of numbers representing bids from vendors X, Y and Z.
In the Winner column I use Nested IF statements utilizing the MIN command to determine which vendor bid the lowest and then I use just the MIN command to list the lowest bid. X Y Z Winner $1 $2 $3 X $1 $3 $2 $4 Y $2 $3 $3 $2 Z $2 $2 $3 $4 X $2 $3 $2 $4 Y $2 $4 $5 $2 Z $2 $16 $17 $19 $11 $3 $4 $4 I have summed each column to determine the total bid amount of each vendor. How do I sum up each column such that only that vendors winning bid is totalled? Eg. Vendor X bid a total of $16 for all items. Its winning bids totalled $3. I will then use the total value of all lowest bids ($11) to determine the percentage that each vendor won of the total amount. Eg. Vendor X is getting 27% ($3/$11) of the total amount of the contract. The problem I'm having is how I go about determining that $3 total for vendor B. Help appreciated! |