Hi, welcome to the forum
Im not sure if that file is protected or what (I dont use google docs much), but I am unable to type anything into it.
Besides, please upload your workbook to the forum, not all members are able - or willing - to open files like that.
THis will kinda do what you want, but you need to enter the values into the formula manually...
G H I J 2 1 3[BGCOLOR=#FFFFFF]6[/BGCOLOR] 3 2 3 4 3 4 5 4 5 6 5 6 7 6 1
J2=SUM(SUMIF(H2:H10,{3,4},G2:G10))
Bookmarks