Hi, I need some help writing an array formula in calc. Here is what it looks like:
I have a table with two sets of columns. One set of columns represents a payment method (Cash, Credit Card, Cheque); another set of columns represents the article purchased. What I want is to calculate, at the bottom of the table, the total amount received for each payment method. The price for each item is in another cell in the spreadsheet. I'm pretty sure I can only get by using an array formula, but I'm not sure how to make it work. Can anyone help out? Thanks, L -- Get free public speaking and communication tips by registering at http://www.duperval.com Bring out the speaker in you! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
