Re: 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,

. Moderator, Blind Access Help.
. Owner: Alacorn Computer Enterprises
"own the might and majesty of an alacorn"
. proprietor: Inthane's Grab Bag
for blind computer users and Programmers!

----- Original Message -----
From: "Ann byrne" <annakb@...>
To: "The Jaws for Windows support list." <jfw@...>
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.

To do this, you need a way to tell Excel to add the number *only if Wal-Mart is the store.

1. Set an indicator for Wal-mart. Possibly something like add numbers if column g = w. the formula looks like this:


=a1 (the Wal-mart 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

Jfw mailing list

Join to automatically receive all group messages.