Is there any way to...

[kbriand]

Hey there, New to excel and trying to figure out how to set up a formula
that would let me use one Column (C) to decide whether or not a value in
the same row but in column b gets used in a =Sum function.

Basically I have a list of items in column A, Their prices in column B
and a Total in Column D for all the prices. Now, since some of the
things in column A are packages of several items at a lower price then
the items individually the only way to get just the value with the
packaged deals is to edit the =Sum function to skip over the cells with
the individual items prices ( least as far as I can see) which is a pain
in the butt.

So i tried to set up column c with an =if function using "Y" as the
logical test ( so i could hit y next to the different items and easily
check out different 'purchases' ) and just couldn't get it to work.

So, Is there a way to use one column ( or cell ) to decide whether
another cells value will be added in a sum function?

Any help would be greatly appreciated.

 

[Rob]

Ummmm
You're going to have to explain that in a bit more detail.

 

[Ryan Allen]

My Advice would be to use the IF() Function in Column C to decide if the Row
is to be calculated. Mark by use If this... mark X if not... leave blank.
Then use the SumIf() function to sort through Coulmn C and to sum the totals
for anything that may be marked with an X.

SumIf(range,criteria,sum_range)

 

[kbriand]

Thank you, this works like a dream. I don't know how to thank you enough.