Hi all,

I have a list of related accounts in column P, and the sales budgets on
Sheet1. I have tried the following formula to get the total sales budget for
all of the related accounts as follows:

=SUMIF(Sheet1!S:S,Sales!P4:P50,Sheet1!E:E)

entered as an array formula. This does not work, but I hope from this that
it is clear what I was trying to do.

How can this be achieved?

Thanks,

Tim