VLOOKUP to sum multiple cells

[thewavgod]

I have a workbook that has multiple sheets and I use the VLOOKUP to grab certain info on a particular date to populate a cell on a form. The simple formula I use to grab a simple single entry is =VLOOKUP(A15,MSEQ648!A:F,6,FALSE), where A15 is the cell that references the time/date row and then grabs the number I need.

What I need to do is to grab multiple time/date rows and then total them. I understand the formula above, but I can figure out how to add multiple cells in the same column. Example in plan English...The time/date rows would be A15 through A23, on sheet!, columns A:J, column 10.

How do I have excel add these 8 cells.

Thank you in advance!!

 

[jorismoerings]

try this:

=SUMIF(MSEQ648!A:A,A15,MSEQ648!F:F)

 

[jorismoerings]

i stand to correct:

=SUM(SUMIF(MSEQ648!A:A,A15:A23,MSEQ648!J:J))

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

Note: Do not try and enter the {} manually yourself