Need code to exclude cells in autosum average based on other cell values

[TrueFangz]

Hi Folks,

In a basic example, say I have data in cells A1 thru D20.

I would make D21 a cell with a formula to average the values from D1,D20. But exclude a couple rows based on certain values that are entered in in the same row in column A.

For instance, if cell A12 = ABC or DEF, then cell D12 would be excluded from the autosum of column D. This scenario could apply to multiple rows, and won't always be on the same rows. As in, there could be an instance where if cell A12 and A15 = ABC or DEF, exclude D12 and D15. (I'm thinking maybe a typical relative cell formula would be ideal so I could basically say if a cell 4 columns to the left contains certain values, then exclude from the autosum.)

Hope this makes sense, and if so, perhaps someone can give me ideas.

[WideBoyDixon]

You can use something like this:

Please Login or Register  to view this content.

WBD

[TrueFangz]

Thanks WBD,

That's quite helpful. Would you know how to integrate that into a relative cell format? My data won't always be between rows 1 and 20. Sometimes it could be more or less cells, so this is what I've just come up with to define the first and last row that needs to be in the equation.

Please Login or Register  to view this content.

I can do a simple average with something like this:

Please Login or Register  to view this content.

But I'm not quite sure how I can incorporate your suggestion as far as telling it to exclude the data from column A.

[WideBoyDixon]

Try like this:

Please Login or Register  to view this content.

WBD

[TrueFangz]

Brilliant! Works great. Thanks much