Hi,
you could try an array SUM (confirmed with control+shift+enter)
but there are for sure better and more elegant solutions.
=SUM(IF(ISBLANK($C16),1,$C$43:$C$211=$C$16)*(Sheet1!$A$43:$A$211=$A16)*(Sheet1!$B$43:$B$211=$B16)*Sheet1!$P$43:$R$211)
Regards
Last edited by canapone; 04-28-2012 at 01:56 AM.
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
skysurfer 
Register To Reply
Bookmarks