Sumif with child based on criteria of other column?

Gerson Robles

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?

Atus Bartal

Dear Gerson,

try this: =SUMIF(Quarter:Quarter, 1, Budget:Budget)

Atus

Gerson Robles

You are the man! Thanks :-)

Gerson Robles

Actually...Atus - when I try to sum if the quarter cell = 2 it ruins the other totals and nothing works... :-(

 

Gerson Robles

Saying its a circular reference

 

Gerson Robles

It's all right - got it working. THanks,

 

Atus Bartal

 good to hear