I want to make a price list for our salemen.
Ihave all the items and the optional items listed.
Now what I would like is be able to put a check mark beside the items and
have the total of all the items selected at the bottom.
Can this be done?

You may want to look in the help index for SUMIF
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"touchngo" <(E-Mail Removed)> wrote in message
news:9DE4494D-0655-403B-B296-(E-Mail Removed)...
>I want to make a price list for our salemen.
> Ihave all the items and the optional items listed.
> Now what I would like is be able to put a check mark beside the items and
> have the total of all the items selected at the bottom.
> Can this be done?
>

I must be missing something.
I want to add numbers in colum B if there is a check mark in colum A.


"Don Guillett" wrote:

>
> You may want to look in the help index for SUMIF
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> (E-Mail Removed)
> "touchngo" <(E-Mail Removed)> wrote in message
> news:9DE4494D-0655-403B-B296-(E-Mail Removed)...
> >I want to make a price list for our salemen.
> > Ihave all the items and the optional items listed.
> > Now what I would like is be able to put a check mark beside the items and
> > have the total of all the items selected at the bottom.
> > Can this be done?
> >
>
>

OK. try this
=SUMPRODUCT((LEN(TRIM(a1:a21))>0)*b1:b21)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"touchngo" <(E-Mail Removed)> wrote in message
news:E2901570-44B8-4895-B154-(E-Mail Removed)...
>I must be missing something.
> I want to add numbers in colum B if there is a check mark in colum A.
>
>
> "Don Guillett" wrote:
>
>>
>> You may want to look in the help index for SUMIF
>> --
>> Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software
>> (E-Mail Removed)
>> "touchngo" <(E-Mail Removed)> wrote in message
>> news:9DE4494D-0655-403B-B296-(E-Mail Removed)...
>> >I want to make a price list for our salemen.
>> > Ihave all the items and the optional items listed.
>> > Now what I would like is be able to put a check mark beside the items
>> > and
>> > have the total of all the items selected at the bottom.
>> > Can this be done?
>> >
>>
>>

Thanks that work perfect.

Would you know how to make a check mark show when I click on a cell and then
have it disapear again if I click again.

"Don Guillett" wrote:

> OK. try this
> =SUMPRODUCT((LEN(TRIM(a1:a21))>0)*b1:b21)
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> (E-Mail Removed)
> "touchngo" <(E-Mail Removed)> wrote in message
> news:E2901570-44B8-4895-B154-(E-Mail Removed)...
> >I must be missing something.
> > I want to add numbers in colum B if there is a check mark in colum A.
> >
> >
> > "Don Guillett" wrote:
> >
> >>
> >> You may want to look in the help index for SUMIF
> >> --
> >> Don Guillett
> >> Microsoft MVP Excel
> >> SalesAid Software
> >> (E-Mail Removed)
> >> "touchngo" <(E-Mail Removed)> wrote in message
> >> news:9DE4494D-0655-403B-B296-(E-Mail Removed)...
> >> >I want to make a price list for our salemen.
> >> > Ihave all the items and the optional items listed.
> >> > Now what I would like is be able to put a check mark beside the items
> >> > and
> >> > have the total of all the items selected at the bottom.
> >> > Can this be done?
> >> >
> >>
> >>
>
>