+ Reply to Thread
Results 1 to 2 of 2

Need formula to tie cost of service to service code

  1. 03-23-2005, 12:42 PM #1
    mkrebs is offline
    Registered User
    Join Date
    03-23-2005
    Location
    Dallas, TX
    Posts
    2

    Exclamation Need formula to tie cost of service to service code

    I need help with crafting a formula that will tie the cost (dollar amount) of a program service to a specific code, and then another formula which will allow me to capture the total dollar amount for the specific services within an extensive range which contains multiple program service codes.

    Thank you!
    Reply With QuoteRegister To Reply
  2. 03-23-2005, 01:53 PM #2
    BenjieLop is offline
    Forum Contributor
    Join Date
    06-23-2004
    Location
    Houston, TX
    Posts
    571
    << I need help with crafting a formula that will tie the cost (dollar amount) of a program service to a specific code,>>

    Check out VLOOKUP for this.

    << and then another formula which will allow me to capture the total dollar amount for the specific services within an extensive range which contains multiple program service codes. >>

    Check out SUMPRODUCT for this.
    BenjieLop
    Houston, TX
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1