What are you trying to do?

=SUMIF(INDIRECT("A1:A10"),"0",INDIRECT("B1:B10"))

--

Regards,

Peo Sjoblom


"dcd123" wrote in
message ...

I would like to run both the indirect and sumif functions in the same
cell and am not quite sure how to structure it.

Any help is greatly appreciated.

Thanks!


--
dcd123
------------------------------------------------------------------------
dcd123's Profile:
http://www.excelforum.com/member.php...o&userid=25396
View this thread: http://www.excelforum.com/showthread...hreadid=479218