I couldn't get the SUMIF function to work for me, but I just used the IF function like so..

=IF(G3="Available (44%):",SUM(H3:I3),IF(G3="Bills (33%):",SUM(H3:I3)))

BUT, I still need a way to get the value to another cell. Is that possible? For example... something like this...

=IF(G3="Available (44%):",K28=SUM(H3:I3),IF(G3="Bills (33%):",K27=SUM(H3:I3)))

Although I know the above won't work.