Vlookup and sum values along a row

**dabrad89** · 09-20-2012, 06:16 AM

Hi and thanks for the help on my last topic here's my issue:

Im trying to vlookup from another worksheet referencing an account number and returning a revenue value from a set coloumn, I have revenue figures for each month and want to pull the sum of 3 months revenue for instance so I can compare 3 months from this year with the same 3 months last year... so far I have this formula

=SUM(VLOOKUP(A1989,'Other Work Sheet'!$A$1:$IV$65536,{73,74,75,etc},0))

This formula is pulling only the 1st value in column "73" it is not adding the values of 74, 75, and soo on ...

**TMS** · 09-20-2012, 06:45 AM

I'm guessing that you'd have to commit that formula with Ctrl-Shift-Enter rather than just Enter.

Looks as though it is an array formula. Give it a try.

Regards, TMS

Edit: yep, just tested it out - array enter it.

**dabrad89** · 09-20-2012, 10:36 AM

Thanks Bro

**TMS** · 09-20-2012, 10:45 AM

You're welcome. Thanks for the rep.

**Cutter** · 09-20-2012, 10:58 AM

@ dabrad89

Welcome to the forum.

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.