+ Reply to Thread
Results 1 to 3 of 3

Requesting help regarding IF function

  1. #1
    Registered User
    Join Date
    12-24-2015
    Location
    Denver, CO
    MS-Off Ver
    Office 365
    Posts
    5

    Requesting help regarding IF function

    excel help.JPG

    Hi Friends,
    I require a small help regarding IF function in Excel.
    If you see in the above table, there are 5 columns A,B,C,D,E.
    Rows 101 - 108 contains various input values & Rows 110 - 113 is where outputs should be displayed.

    Now all I require is an addition operation to be performed at D110 & E110 where, in the 110th row, corresponding to London, all the values in column D, having London in column C should be added and the output is to be displayed at D110.

    Likewise for the output cell of E110 where all the values of the column E having London in their corresponding column C should be added and the result is to be displayed at E110 cell.

    I tried all the available functions, but could not do so. Normally in case of 100 rows or columns, I can do it manually, but when faced with 1000's of rows and columns, its very difficult to manually select all those cells to perform any arithmetic operations.
    So I require your valuable suggestions and advices.

    Thank You in advance.
    Last edited by venu619; 12-25-2015 at 12:31 PM.

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Requesting help regarding IF function

    Using your posted scenario...
    This formula, copied across and down, returns the totals for the referenced location
    Please Login or Register  to view this content.
    Because of your location, you may need to replace the commas with semicolons.




    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    12-24-2015
    Location
    Denver, CO
    MS-Off Ver
    Office 365
    Posts
    5

    Re: Requesting help regarding IF function

    That's perfectly working,

    Thank You very much Mr. Ron Coderre.

+ 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. [SOLVED] Requesting debugging help
    By Butcher1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-01-2015, 04:22 PM
  2. Automated SUM of a function over a data range?; Requesting Help
    By k12881 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-28-2013, 01:14 PM
  3. Requesting help with date function
    By Kitkatlv in forum Excel General
    Replies: 2
    Last Post: 11-05-2012, 10:02 PM
  4. Help In Requesting Data
    By pasteis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-03-2012, 01:14 PM
  5. Requesting Help with Macro
    By Endlin3 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-08-2010, 06:39 PM
  6. Requesting a simple counting function, pretty urgent (VBA)
    By ssdt in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2008, 08:47 PM

Tags for this Thread

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