[mso] Using SumIF in XL2k
- From: "4office" <4office@xxxxxxxxxxxxx>
- To: "Office (E-mail)" <mso@xxxxxxxxxxxxx>
- Date: Mon, 11 Nov 2002 09:45:29 -0500
Hi everybody, I am trying to figure out the best way to write a formula... I
think SUMIF might work, but I am not sure how to write it... This is what I
am trying to do
I have the following fields: I am trying to figure out a formula that will
calculate the total for all checks cleared and all checks uncleared. Thanks
April..
Please cc your response to arpace@xxxxxxxxxxxxx
Totaled Cleared_____________
Totaled outstanding_________
Row A B C
4 check no amount cleared date
5 1001 541 25-Oct
6 1002 254 10-Oct
7 1003 654 26-Oct
8 1004 125 22-Oct
9 1005 741
10 1006 258
11 1007 745 29-Oct
12 1008 654 29-Oct
13 1009 987
14 1010 421
15 1011 451 30-Oct
16 1012 325
17 1013 325
18 1014 1452
19 1015 984 30-Oct
20 1016 555
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
