Can anyone help with SQL in an active link?

I am trying to create a result set and insert it into a table so that our
HelpDesk can see how many of each priorities a tech has. This will allow to
better load balance the workload. But I can't get the IF statement to
work.

Select C4 as 'Assigned to Individual', Sum(IF (SELECT C5 FROM T674 WHERE C5
= 1)then 1 else 0) as 'Column1', Sum(IF (SELECT C5 FROM T674 WHERE C5 =
2)then 1 else 0) as 'Column2') from T674
Group by C4

And to be quite honest, I don't know if this can even be done. But I think
it can??

Thanks for any help.

Bruce