+ Reply to Thread
Results 1 to 2 of 2

Formula to sum up all the fees by Division

  1. #1
    Registered User
    Join Date
    10-08-2008
    Location
    Hallandale
    Posts
    44

    Formula to sum up all the fees by Division

    I need a simple formula that will add up all the fees according to the division.


    I know I can use subtotals or similar but I don't want to use it becuase it will conflict with my future demands with other formuulas.

    Thanks
    Attached Files Attached Files
    Last edited by koklok; 10-08-2008 at 09:06 PM.

  2. #2
    Forum Contributor
    Join Date
    07-24-2008
    Location
    Athome
    MS-Off Ver
    Excel 2013
    Posts
    127
    =SUMIF($D$2:$D$16,$H2,$B$2:$B$16)

    copy and paste down

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula needed to tell me if a value exists
    By WhatF in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-10-2008, 08:16 AM
  2. Dragging a formula, but keeping certain values
    By sprackers in forum Excel General
    Replies: 1
    Last Post: 05-13-2008, 10:59 AM
  3. Conditional formula question
    By odditie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-27-2007, 09:47 PM
  4. How do I subsitute part of a formula linked to another workbook?
    By Scej12 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-03-2007, 10:10 AM
  5. use cell content as cell address in formula
    By nnsc in forum Excel General
    Replies: 4
    Last Post: 11-05-2006, 03:12 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1