I'm needing to get the SUM amount of dollars from the "Budget" column if that row is a "1" in the Quarter column...the rows are children...please help?
Dear Gerson,
try this: =SUMIF(Quarter:Quarter, 1, Budget:Budget)
Atus
You are the man! Thanks :-)
Actually...Atus - when I try to sum if the quarter cell = 2 it ruins the other totals and nothing works... :-(
Saying its a circular reference
It's all right - got it working. THanks,
good to hear
