 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2006Conditional Formula?
Hi- I need help creating a formula that sums values in a list based on the value in an adjacent cell. Please see attached screen shot. Hopefully it explains what I'm trying to do. Thanks. +-------------------------------------------------------------------+ |Filename: excel help 3-10-06.gif | |Download: http://www.excelforum.com/attachment.php?postid=4442 | +-------------------------------------------------------------------+  Signaturerhovey Sounds like you could use SUMPRODUCT or SUMIF to get what you want. Say your cash/lease drop downs are in column A. Where you want your cash total you could use, =SUMPRODUCT(--(A1:A100="Cash"),--(B1:B100)) For lease =SUMPRODUCT(--(A1:A100="Lease),--(B1:B100)) or =SUMIF(A1:A100,"Cash",B1:B100) =SUMIF(A1:A100,"Lease",B1:100) Does that help? Steve SignatureSteveG |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.