Help with formula Sum IF i think ?

ed_2868

Hi I Am after some help getting a column of numerals to add only if certain criteria in a drop box are met  

say if Column A was made up all of the number 2 and Column B i had drop box criteria of "Complete"

If i marked Column B "complete" my value would be 2 if i mark 4 Rows in Column B "Complete" my total would be 8 

Any help with this would be amazing 

Thanks in advance    

 

Andrée Starå

Hi Ed,

Try this.

Formula: =SUMIF(CHILDREN([Column B]@row); "Complete"; CHILDREN([Column A]@row))

Please see the attached link/screenshot for more information.

SUMIF Complete

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Anthony Caole

Please confirm that in the US your semi-colons should be commas.

Andrée Starå

Hi Anthony,

From a while back I always add this to my answers to be certain that the formula will work for other areas.

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Best,

Andrée

Anthony Caole

Mange tusen takk Andree, takk for innsatsen og for stadig kompetent rådgivning! (YFU International Exchange Student Norway, 1986). 

Andrée Starå

Tack!

Ingen orsak Anthony! < (Swedish)