Help need help with a sum, look

[MacNeil]

Hello,
i have sheet 1 that is the lookup, sheet 2 is the find and return the total of column3. I keep getting ref# or N/A. I need to sum all instances of A17 from sheet 2. My formula is
{=sum(vlookup(A17,'Sheet2'!B1:B30,3,false))}
Any help is greatly appreciated

 

[Aladin Akyurek]

Try rather:

=SUMIFS(Sheet2!D:D,Sheet2!B:B,$A17)

Does this return what you intend?

 

[MacNeil]

Hello,
Thank you for the quick response, it is really appreciated. I did not explain very well, I have sheet 1 that has account Number I want to lookup sheet 2 and total all the amounts that have the same account number, my formula only picks up the first amount. Again thank you for all the assistance

 

[Aladin Akyurek]

Hello,
Thank you for the quick response, it is really appreciated. I did not explain very well, I have sheet 1 that has account Number I want to lookup sheet 2 and total all the amounts that have the same account number, my formula only picks up the first amount. Again thank you for all the assistance

In B17 of Sheet1 enter:

=SUMIFS(Sheet2!D:D,Sheet2!B:B,$A17)

where A17 is an account number of interest

 

[MacNeil]

ThANK YOU!!! You have saved me so much time, It worked, I was driving myself crazy again thank you

 

[Aladin Akyurek]

ThANK YOU!!! You have saved me so much time, It worked, I was driving myself crazy again thank you

Glad to help.