adding variable sums from different cells

**ioneabee** · 05-07-2010, 11:12 AM

hi all
looking to add the contents of cells as per the attachement ie cell A5 & A9 both have contents noted as "a1", I then need to add the contents of C5 & C9.
so basically I need to add all "a1's", all "a2's", all "a3's" etc (note that these are not cell numbers - they are time codes - if that makes sense)
I've added the excel sheet which clearly shows what i'm trying to do
thanks

**martindwilson** · 05-07-2010, 11:21 AM

=sumif($a$5:$a$20,k6,$c$5:$c$20)

**ioneabee** · 05-07-2010, 11:39 AM

Hi thats great - but can we also have a blank cell if the result is 0

thanks

**martindwilson** · 05-07-2010, 01:08 PM

=if(sumif($a$5:$a$20,k6,$c$5:$c$20)=0,"",sumif($a$5:$a$20,k6,$c$5:$c$20)) is one way there are others

**ioneabee** · 05-12-2010, 04:49 AM

Hi

I now need to enter an empty "total" cell (text) if the other cells are empty, otherwise enter a dash "==="
I know this formula is incorrect but hopefully it gives you the gist of what I'm trying to do

=IF((Monday!I30)and(Tuesday!I30)and(Wednesday!I30)and(Thursday!I30)and(Friday!I30)="","","=====")

many thanks in anticipation