Adding

[DGebert]

I am making a workbook for an auction. I was hoping maybe someone could answer my question.

1. I was needing a formula that would add up all the prices for a specif buyer based on his number. His number is in one cell and his price is in another.

 

[Michael M]

Have a look at the SUMIF or COUNTIF functions.
Alternatively, provide some real data that we can work with and someone may write the formula for you ....

 

[sericom]

If his numbers are in column A and prices in B, then this should work:

=SUMIF(A:A,"5",B:B)

I used 5 as his number in that example

 

[DGebert]

Will this work if it is being used to add up 4 different pages? If not do you know how to do it?

 

[Michael M]

SUMIF can't do 3d calculations....but read here for an alternative

https://www.mrexcel.com/forum/excel-questions/593129-sumif-across-multiple-sheets.html