Combine Indirect and Sumif

D

dcd123

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!
 
D

dcd123

Let's see if I can explain this:

I have a workbook with many sheets. I have created a summary shee
that brings in information from the other sheets.

I want the indirect function to return a number from a specific cel
from each sheet next to the relative name. Then I want to subtrac
from that number the amount that has already been paid for the yea
(this is where I'm thinking I need to use the Sumif), this number is o
the summary sheet, but I want to use a criteria to return the relativ
amount. Then I want to divide that result by the number of remainin
months in the year.

So I need to combine the two functions:

=INDIRECT($A82&"!"&$C$2)

Minus

=SUMIF(A3:A158,A82,C3:C158)

/11

I hope that helps
 
Top