#### Entries In Excel

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

Steve & Shannon Cook

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 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+SUMIF(c1,"w",b1)

=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

inthane <inthaneelf@...>

ah yes, even better, haven't used formulas other than simple ones in years, thanks for taking it beyond my simple workup,

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.the-jdh.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.

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+SUMIF(c1,"w",b1)

=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
Jfw@lists.the-jdh.com
http://lists.the-jdh.com/mailman/listinfo/jfw_lists.the-jdh.com

 1 - 3 of 3