Function for cell ranges and add cell*

[diltdr]

Hey,

I have a function where I display data from cells H7 to H13 as below:

=SUM('Trade Data'!H7:H13)

I want to also include data from other cells, for example H16 and H19, I cannot enter !H7:H19 as it would include H17 and 18 also which I do not want displayed.

Any help would be appreciated, thanks

[Fluff13]

How about
=SUM('Trade Data'!H7:H13,'Trade Data'!H16,'Trade Data'!H19)

[diltdr]

How about
=SUM('Trade Data'!H7:H13,'Trade Data'!H16,'Trade Data'!H19)

That works thank you, I have another small issue. I have another function that reads:

=AVERAGEIF('Trade Data'!Q7:Q13,"<0")

Unfortunately the fix does not work here, perhaps because there is alreay an , used here?

thanks

[Fluff13]

You cannot do that with the averageif function, it needs a single range.

[diltdr]

You cannot do that with the averageif function, it needs a single range.

Is there a way of expressing it as say; H7 + H8 + H9 + H15 etc?

[Fluff13]

Not using th averageif function, no.
Will there be negative values in between Q13 & Q19?

[diltdr]

Not using th averageif function, no.
Will there be negative values in between Q13 & Q19?

Yes there will likely be negative values also in most cases

[Fluff13]

Not very elegant, but try
=(SUMIF(Q7:Q13,"<0")+IF(Q16<0,Q16)+IF(Q19<0,Q19))/(COUNTIF(Q7:Q13,"<0")+(Q16<0)+(Q19<0))