Newbie--Help

[DavidBack]

Hello All!!!,
I am tring to figure out a way to make some sort of condintional fromula. I have three text variables
ie. programs, workshops, and other. I want to have all the programs sum into a cell and all the workshops sum into another cell and so on. How would I go about oding this?

Is there a way to import my little under-contrsuction spreadsheet in here so you all can take a look at it?

Thanks In Advance for any info,
David

 

[shades]

If there is only one condition for each, then suppose that A1:A10 has programs and D1:D10 has costs, then use

=SUMIF($A$1:$A$10,"Programs",$D$1:$D$10)

Adjust ranges accordingly.

 

[DavidBack]

I am kinda confused(and a lil stupid).
this is a little more specific on layout:

cell A5-A25 has a customer's name. B5-25 will have either "programs', "workshop" or "other". D5-25 will have the value/cost in relation with programs/workshop/other in B5-B25. I need it to sum all cells relating to "programs"(B5-B25) and the corresponding value(D5-D25) sum of all "programs" to cell B26. Value of all workshops to B27 amd value of all "other" to B28

so basically I need to have all the "programs" which maybe entered into cells any of the cells D5-D25 and their related cost found in D5-25 to sum into a cell C27

Thanks again for helpin the new guy
Dave

 

[DavidBack]

anyone?...

 

[shades]

Put this in C27

=SUMIF($B$25:$B$25,"Programs",$D$5:$D$25)

In D27

=SUMIF($B$25:$B$25,"Workshop",$D$5:$D$25)

In E27

=SUMIF($B$25:$B$25,"Other",$D$5:$D$25)