Vlookup...sumif...?

[Pratt]

Hi All,

Seems like a lovely, helpful community from posts I've searched tryin
to find this answer before creating my own thread.

I'm not totally new to Excel however I'm pretty green when it comes t
using formulas beyond very simple things.

I have a workbook with multiple worksheets, essentially what I'm tryin
to accomplish here is have cell D2 in worksheet1 display a sum o
columns J,N & Q from worksheet2 if the row in the worksheet2's column
is "ABFD" for example.

I'm just lost how to write the formula for it, any help is appreciated

 

[ToniLM]

Hi All,

Seems like a lovely, helpful community from posts I've searched tryin
to find this answer before creating my own thread.

I'm not totally new to Excel however I'm pretty green when it comes t
using formulas beyond very simple things.

I have a workbook with multiple worksheets, essentially what I'm tryin
to accomplish here is have cell D2 in worksheet1 display a sum o
columns J,N & Q from worksheet2 if the row in the worksheet2's column
is "ABFD" for example.

I'm just lost how to write the formula for it, any help is appreciated.

Without an example is challenging to know what you mean