Vlookup...sumif...?

P

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
 
T

ToniLM

Pratt;1608379 said:
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.
Click to expand...

Without an example is challenging to know what you mean
 
Top