# Newbie--Help

#### DavidBack

##### New Member
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

### Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
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)

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

anyone?...

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)

Replies
0
Views
81
Replies
8
Views
243
Replies
6
Views
192
Replies
3
Views
132
Replies
9
Views
374

1,203,506
Messages
6,055,806
Members
444,825
Latest member
aggerdanny

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back