Vlookup to sum multiple rows

[cryjoh30]

I need to look up data that is in another sheet and sum the rows.

I am using this formula =IFERROR(VLOOKUP($A19&C$3,'Actual Data'!$A$2:$L$316,12,FALSE),0)

And it works great, but it is only returning the 1st value. I need the sum of all rows that match A19 (the dept code) & C3 (the Dept).

Thanks for the help.

[Tony Valko]

Try this:

=SUMIF('Actual Data'!$A$2:$A$316,$A19&C$3,'Actual Data'!$L$2:$L$316)

[ConneXionLost]

How about:

Please Login or Register  to view this content.

[cryjoh30]

Wonderful! That worked. Thanks a bunch

[Tony Valko]

You're welcome. Thanks for the feedback!