I have a list that is probably 20 rows long.
The list is 4 columns wide. The columns are Dealer #, Quote #, Quantity, and
Status.
Status is a data validation list box with 3 different options (Pending, Won,
Lost).
I need to have 3 different totals, one for each of the options. So I want a
total of the quantities for each "Pending", "Won", "Lost".

Please advise,
Let me if you need any other information.

Thanks
Travis.

Hi Travis,

You could use something like this...


=SUMIF(D222,"Pending",C2:C22)

This will sum the total quantity of status Pending

Assuming Status range is D222 and Quantity is C2:C22

Hope this helps,

Gav.

"Tdahlman" wrote:

> I have a list that is probably 20 rows long.
> The list is 4 columns wide. The columns are Dealer #, Quote #, Quantity, and
> Status.
> Status is a data validation list box with 3 different options (Pending, Won,
> Lost).
> I need to have 3 different totals, one for each of the options. So I want a
> total of the quantities for each "Pending", "Won", "Lost".
>
> Please advise,
> Let me if you need any other information.
>
> Thanks
> Travis.

Assuming Quantity is in column C and Status is in column D, use these formulas:

=SUMPRODUCT(C1:C100,--(D1100="pending"))
=SUMPRODUCT(C1:C100,--(D1100="won"))
=SUMPRODUCT(C1:C100,--(D1100="lost"))

--
Gary''s Student - gsnu200771


"Tdahlman" wrote:

> I have a list that is probably 20 rows long.
> The list is 4 columns wide. The columns are Dealer #, Quote #, Quantity, and
> Status.
> Status is a data validation list box with 3 different options (Pending, Won,
> Lost).
> I need to have 3 different totals, one for each of the options. So I want a
> total of the quantities for each "Pending", "Won", "Lost".
>
> Please advise,
> Let me if you need any other information.
>
> Thanks
> Travis.

Try this:

=SUMIF(D1100,"Pending",C1:C100)

HTH,
Paul

--

"Tdahlman" <(E-Mail Removed)> wrote in message
news:8FDB4AE5-186D-4ED6-8674-(E-Mail Removed)...
>I have a list that is probably 20 rows long.
> The list is 4 columns wide. The columns are Dealer #, Quote #, Quantity,
> and
> Status.
> Status is a data validation list box with 3 different options (Pending,
> Won,
> Lost).
> I need to have 3 different totals, one for each of the options. So I want
> a
> total of the quantities for each "Pending", "Won", "Lost".
>
> Please advise,
> Let me if you need any other information.
>
> Thanks
> Travis.

Are you sure that's correct? I had to use:

=SUMPRODUCT(--(D1100="Pending"),C1:C100)

--

"Gary''s Student" <(E-Mail Removed)> wrote in message
news:A80271C4-E5E3-480C-8C82-(E-Mail Removed)...
> Assuming Quantity is in column C and Status is in column D, use these
> formulas:
>
> =SUMPRODUCT(C1:C100,--(D1100="pending"))
> =SUMPRODUCT(C1:C100,--(D1100="won"))
> =SUMPRODUCT(C1:C100,--(D1100="lost"))
>
> --
> Gary''s Student - gsnu200771
>
>
> "Tdahlman" wrote:
>
>> I have a list that is probably 20 rows long.
>> The list is 4 columns wide. The columns are Dealer #, Quote #, Quantity,
>> and
>> Status.
>> Status is a data validation list box with 3 different options (Pending,
>> Won,
>> Lost).
>> I need to have 3 different totals, one for each of the options. So I want
>> a
>> total of the quantities for each "Pending", "Won", "Lost".
>>
>> Please advise,
>> Let me if you need any other information.
>>
>> Thanks
>> Travis.