1. ## Add Values Incrementally (2002)

I want to be able to check off rows in a cash resources sheet and have them added up if checked. Not quite sure how to do this. I want the results to be in a cell.

2. ## Re: Add Values Incrementally (2002)

In the first place, Excel is not the ideal application if you really want check boxes. It is possible to put a check box in a lot of rows, but you have to do a lot of work. What happens if rows are added or deleted?

If you can live with a column in which you enter (for instance) 1 for rows to be "checked", things are a bit easier.

Do you want a sum for each row - to be calculated only if that row is checked? Or do you want one sum over all checked rows?

3. ## Re: Add Values Incrementally (2002)

I just want it to work. Good point on deleting rows had not thought of that. I just want a sum in one cell.
Thnaks
Frank

4. ## Re: Add Values Incrementally (2002)

Agree with Hans. Rather than a checkbox, use a 1 to indicate checked, or a single letter, such as "Y", or "P" if it's for presented checks, or whatever suits. Then if the range of numbers is A1:A50 and the range of "check codes" is B1:B50 and the checkoff code is the letter "Y", in your single cell formula use:

=SUMIF(B1:B50,"Y",A1:A50)

HTH.

5. ## Re: Add Values Incrementally (2002)

Not quite what I'm trying to do.
Let's say on row 1 I have cash available 5.00.
On row 2 Bank funds available is 10.00
and so forth.
If I check row 1 or put a 1 that is the total say in Cell A!.
If I also put a 1 in row 2 this is added to the vailue in A!

6. ## Re: Add Values Incrementally (2002)

I'm confused about the data layout. Can you post a sample of your layout?

7. ## Re: Add Values Incrementally (2002)

If I understand your description, that is exactly what John's formula does. If you have tried his formula and it does not do what you want, then could you post an example workbook to show us what you mean?

8. ## Re: Add Values Incrementally (2002)

See the attached workbook. Does that help?

9. ## Re: Add Values Incrementally (2002)

Thanks all for your help things are working now.
Frank
sorry for the delary out of town

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•