# Absolutely Clueless...

#### JonathancM

##### New Member
Hi there,

I am trying to create a really basic finances spreadsheet and require a formula for the following. The only way I can describe it is thus...

When C3 = True (I don't know what True could be, perhaps a "Y", how can I make this so?), I need C12 (my monthly remainder) to equal C2-B3.

I'd then need this formula to go all the way through C4-C11 too, all having an effect on C12, i.e. C4=Y then C12=C2-B4 etc...

I know what I have written is possible gobbledegook, but hey, we all gotta start somewhere right??

I looked at tick boxes for this purpose too (instead of "Y"), but my brain farted and I was unconscious for several days.

Any help appreciated!

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

#### Smitty

##### Legend
Welcome to the Board!

For the True/False-Yes/No options you can use Data Validation. Goto Data-->Validation-->Allow-->List-->Source-->True,False or Yes,No. Now you'll have an in-cell drop-down list with those values.

If you want to post a shot of what you have now PM me your e-mail address and I'll send you the board's HTML maker.

HTH,

#### JonathancM

##### New Member

How's that?
The letter 'B' is C2 'A' B3, etc...

Last edited:

#### Smitty

##### Legend
OK, I think this might be what you're after:

=SUMIF(\$B\$3:\$B\$14,"Y",C\$3:C\$14)

HTH,

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,168,113
Messages
5,857,453
Members
431,880
Latest member
kar2rost

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