# Sumif and Vlookup combination?

1. ## 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. 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. 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. I still may be thinking incorrectly, but how about:

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

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

#### 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