SUMIF - Referencing another sheet

Shal

I'm trying to sum based on certain Streams(column name) in another sheet 'Register' 

Stream data is as:

Emergency

Youth

 

The formula I've used is:

=SUMIF({Register Range 3}:{Register Range 3}:, "Emergency")

I'm getting an unparseable error

 

Please help!

Andrew Stewart

You need to create two referenced ranges on the Register sheet, one containing the column "Stream", and another containing the column (let's call it "Amount") that you want to total. The formula becomes:

 

=SUMIF({Register Amount Column},{Register Stream Column},"Emergency")

(assuming you rename the ranges as appropriate, rather than just accepting the defaults).

There is no need for ":", the external range must be defined as all the cells you want to look at, either the whole column or a fixed subset.

I hope that makes sense...