SUMIF referring to another sheet is no problem. Maybe the nested SUMIF is
causing a problem.
Show the data and the formula.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"TeeBee0831" wrote in message
...
I want to enter a formula on a different worksheet that contains a SUMIF
function for values on another sheet. The formula has a nested SUMIF that
works fine on the same sheet, but when I try to enter the formula on a
different sheet, the results are wrong or I get an error. Can't this be
done?
|