Sumif Query

[Ron McC]

I am wanting to conditionally sum values that are in a
list that is in a rowFor instance sum of all items in row
101 where row 100 is less than Oct-06. I How do I set the
criterion in a sumif formula to do this?

I've tried =SUMIF(B100:G100,"<E100",B101:G101)which does
not seem to work. Conditional sum seems to be for data in
columns.

Col B Col C Col D Col E Col F Col G
Row 100 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06
Row 101 0 0 10 0 0 10

Even if I convert the table to a columnar format the
conditional sum does not seem to work properly as the
formula seems to recognise the dates in a different way.

TIA
Ron

 

[Ken Wright]

=SUMIF(B100:G100,"<"&E100,B101:G101)

but that will not include the value in E101 the way you have your formula
structured now.