Re: SUMIF Formula Help
- From: "s boak" <sboak.ele@xxxxxxxxxxxx>
- Date: Wed, 2 Nov 2005 09:59:44 -0500
Thanks so much Dave
Very much appreciate the help - and keeping some hair.
Steve
"Dave Peterson" <petersod@xxxxxxxxxxxxxxxx> wrote in message
news:4368D22E.47D2DFF3@xxxxxxxxxxxxxxxxxxx
> Your formula looks ok to me, but I think I would have used:
>
> =SUMIF(C4:C79,"CU16",G4:G79)
> (Not array entered)
>
> But if your formula fails, then mine will too.
>
> Are you sure that you have a cell in c4:c79 that contains CU16 (no
> leading/trailing spaces allowed) and you have numbers in G4:G79 (maybe
> they're
> not numbers, but text).
>
>
>
> s boak wrote:
>>
>> Hi Folks:
>> I have a small table (C4:G85)
>> Col. C is part numbers
>> D-E-F are quantities
>> Col. G is total quantity
>>
>> I'm trying (with no luck) to get a formula that will add the qtys of all
>> part numbers that contain CU16
>>
>> I'm using (entered as array)
>> =SUM(IF(C4:C79="CU16",G4:G79))
>>
>> Would appreciate any guidance.
>> Many thanks.
>> Steve
>
> --
>
> Dave Peterson
.
- References:
- SUMIF Formula Help
- From: s boak
- Re: SUMIF Formula Help
- From: Dave Peterson
- SUMIF Formula Help
- Prev by Date: Re: SUMIF Formula Help
- Next by Date: Re: How do I do this?
- Previous by thread: Re: SUMIF Formula Help
- Next by thread: How do I do this?
- Index(es):
Relevant Pages
|
