hi all,

I need some advice : below is my problem sheet, I want to
sumif I 1 to dv 1 = 1( period ) and g1 to g100 =2 ( which
room ) to get a period total for the period and suite
using one condition of sum if works fine but when I put in
the second condition it errors :

is it possible to achieve this senario ?

1 1 1
week week
1 1 2
03/04/05 09/04/05 15/04/05
1 suite 1 170 170
2 suite 2 132.5 132.5 132.5
3 suite 3 70 70 70
4 suite 4 20 20 20
5 suite 5 10 20 20
6 suite 6 30 30 30

many thanks

steve