Hi Nadine, I've sent you an email with a file that hopefully does what you want. Please don't answer by email, since I have a quite selective spam- filter. Please post to this newsgroup instead. Thanks.
Stuart Redmann wrote: > > I guess that what you wanted to say is that you want to > > get the sum of all payments that have their "Check Date" field set. If > > so, you can use the following formula for cell Amount Paid: > > =SUM(IF(Sheet1!ZS(1)<>0,Sheet1!ZS,0),IF(Sheet1!ZS(6)<>0,Sheet1!ZS(5), > > 0),IF(Sheet1!ZS(11)<>0,Sheet1!ZS(10),0),IF(Sheet1!ZS(16)<>0,Sheet1! > > ZS(15),0),IF(Sheet1!ZS(21)<>0,Sheet1!ZS(20),0)) Nadine S wrote: [snip] > Unfortunately when I put > Stuart's formula into cell C2 on sheet 2, I get #NAME? as the result and not > $1950. I'm sorry, I did not properly translate everything from my German Excel into English, assuming that you have the English version (if you have any other version, I'll have to translate the formula into this language, which is a quite annoying "feature" of Excel ;-) The German "ZS" must be "RC", and this will also only work if you turn on RC-referencing (so that you can reference cell A1 by R1C1). > Stuart, first let me thank you for your email. In response to your comment of > my few misspellings, let me apologize for my hurried email and therefore lack > of > running spell check. According to Brain Connection, "proficient readers read > most words (except very long ones) principally through the first and last > letters and a rapid recognition of the general shape and content of the entire > word. That's why we typically read misspelled words with no trouble." My > misspellings didn't seem so outrageous to me but maybe that's just me. I think that leaving misspellings uncorrected is established behaviour for chatting, but inacceptable for newsgroups and email . I know that this group is a bit different from others (if you posted "Plz hlp me ASAP. URGENT" to comp.lang.c++, you'll most probably not get any answer). > In regards to, "How many columns arel you going to insert into the worksheet?" > I'm assuming that your word "arel" is supposed to be "are". With that > assumption, the answer is "I don't know. As many as needed would have to be > my > best guess at this point. Currently there are 21 but that may need to > increase > in time or possibly even decrease. Basically I just don't know." [snip] > Your assumption that this is to handle lots of rows is correct, however, I > don't > understand what you mean when you said, "(which probably stand for some > client)". Well, I assumed that the payments in a row belong to the same person or company (that's why I used the more abstract term "client" here). I further assumed that there is more than one "client", so you'll have lots of rows, each row for a different client. If this is so, you'll get into trouble if there are lots of clients _and_ lots of payments per client. Regards, Stuart -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
