MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
Topic starter
I want to sum cells B2:G2 if cell A2 is Tuesday (for example).
I think I need to be using SUMIF but can't get it to work.
Column A will include various names and I want to have a separate table below to sum them individually (without making a pivot table which would be easier)
can anyone help.?
Posted : 09/10/2009 11:57 am
=if(a2="Tuesday",sum(B2:G2))
Posted : 09/10/2009 12:03 pm
Topic starter
that's fine for just looking at cell A2, but I want it to sum all the rows where the cell in Column A is Tuesday
Posted : 09/10/2009 12:10 pm
H2 = if(a2="tuesday",1,0)
I2 = H2*sum(b2:g2)
Copy that down etc.
Posted : 09/10/2009 12:32 pm