#### commodoros

##### New Member

- Joined
- Nov 22, 2005

- Messages
- 7

The situation is thus:

I have to create a report everyday based upon a variable number of data entries. Some days there will be 5000 pieces of information. Some days 500.

I want to create a formula that will automatically average several different pieces of information automatically once it is imported from a .csv file.

I need the formula to average the information in column C, but only if it meets the criteria in column A.

A formula like this works when the array is concretely defined

=AVERAGE(IF(A2:A100="East",C2:C10))

But I need to make it work without a concretely defined column C, because as I mentioned earlier, somedays column C will have 5000 entries and somedays it will have only 500.

I would like it to work like this

=AVERAGE(IF(A2:A100="East",C:C))

or

=AVERAGE(IF(A2:A100="East",C2:C10000))

But I can't make it work. Any advice would be greatly appreciated.