+ Reply to Thread
Results 1 to 4 of 4

Sumif and Vlookup combination?

  1. #1
    Registered User
    Join Date
    06-26-2008
    Location
    New Zealand
    Posts
    41

    Sumif and Vlookup combination?

    Hello you gurus. I am trying to use a folmula to sum some values based on TRUE in another column, i.e.

    Column A has at various places a unique text value, "Total". I want to sum a value in the same row as "Total" but as Column B / Column D.

    SUMIF seems to have potetial but only works on a single column and Vlookup seems to have potential but can't work on multiple values. Can they be combined?

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    Hi Rhapsodie,

    Could you explain a bit more?

    You have, at various locations in column A, the word "Total", yes?

    And you want to sum both columns B and D for each of those rows? Or you want to divide column B by column D? That's what I couldn't figure out based on your first post.

  3. #3
    Registered User
    Join Date
    06-26-2008
    Location
    New Zealand
    Posts
    41
    That's all correct. I want to sum all the values where "Total" is found in column A. Each value is Column B divided by column D.

  4. #4
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    I still may be thinking incorrectly, but how about:

    =SUMPRODUCT(--(A1:A100="Total"),B1:B100/D1:D100)

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1