Date
1  3 of 3
Entries In Excel
inthane <inthaneelf@...>
ah yes, even better, haven't used formulas other than simple ones in years, thanks for taking it beyond my simple workup,
toggle quoted messageShow quoted text
elf . Moderator, Blind Access Help. . Owner: Alacorn Computer Enterprises "own the might and majesty of an alacorn" www.alacorncomputer.com . proprietor: Inthane's Grab Bag for blind computer users and Programmers! http://grabbag.alacorncomputer.com
 Original Message 
From: "Ann byrne" <annakb@sbcglobal.net> To: "The Jaws for Windows support list." <jfw@lists.thejdh.com> Sent: Saturday, July 30, 2011 1:29 PM Subject: Re: Entries In Excel The operator is 'sumif', which means add the number only if an indicator is set.


Ann Byrne
The operator is 'sumif', which means add the number only if an indicator is set.
To do this, you need a way to tell Excel to add the number *only if WalMart is the store. 1. Set an indicator for Walmart. Possibly something like add numbers if column g = w. the formula looks like this: a1+SUMIF(c1,"w",b1) =a1 (the Walmart total) b1 the column containing the amount paid for this transaction c1=the indicator. If not 'w', the sum will not happen. The answer will appear in the column where the formula is. Good luck! Add column B to column a only if column C = w


Steve & Shannon Cook <cookcafe@...>
Hi All,
I have our check register in Excel. If I would like to know how much we spent at Wal Mart this year. Is there a formula or some other way we could total these entries in steading of sorting and then totaling them? Using jaws 12 and Excel 2010. Thanks in advance for your help! Steve & Shannon Cook

