Help using SUMIF with multiple Sheets

[Summer of Georg]

I am trying to take information from Sheet 2 and use it in a sumif equation on sheet 3 but I keep getting an answer of 0. Do I put "Sheet 2" in front of the equation? I'm pretty lost.

[Bryan Hessey]

I am trying to take information from Sheet 2 and use it in a sumif equation on sheet 3 but I keep getting an answer of 0. Do I put "Sheet 2" in front of the equation? I'm pretty lost.

Hi,

in the form of

=SUMIF(Sheet2!B:B,A1)

hth
---

[Summer of Georg]

Brian,

Here is my overall problem. Sheet 2 has all the recorded data (with the account number that the purchase was under and I am trying to only use the date for a certain account number. I have been entering the account # in the CRITERIA category and the range of account #'s from the recorded data in the RANGE and then finally the monetary amount (which I am trying to get added up) in the SUM_RANGE category. Sadly for me it keeps giving me zero.

What do i do?

[MSP77079]

Most likely problem is that one of the numbers is not a number, but text. For example, let's say that the sheet with the long list of account numbers and accompanying monetary values has account numbers that Excel thinks are text. And, the criteria you are using is really a number. The SUMIF will fail.

Or vice versa. The account numbers are really numbers, and the criteria you use is "123456". The SUMIF will fail.

Be sure both are numbers. Or, that both are text. You can make numbers text by formatting the column as text. Or, you might be able to convert text to numbers using another column and adding zero. Or, if your criteria are numbers and you want to convert them to text, then for the criteria use something like ""&A2 (assuming the criterion is in cell A2); this will convert the criterion to a text.

Hope this makes sense. I'm typing kind of fast.