Shorten the formula
 

Hello from Steved

This works
=IF($A45="COMMENDATION",SUM('Complaints and
Commendations'!$C12),0)+IF($A45="COMMENDATION",SUM ('Complaints and
Commendations'!$D12),0)

This does'nt, What is needed please
=IF($A45="COMMENDATION",SUM('Complaints and Commendations'!{"C12","D12"}),0)
Thankyou.

Shorten the formula
 

=IF($A45="COMMENDATION",SUM('Complaints and Commendations'!$C12:$d12),0)

Steved wrote:

Hello from Steved

This works
=IF($A45="COMMENDATION",SUM('Complaints and
Commendations'!$C12),0)+IF($A45="COMMENDATION",SUM ('Complaints and
Commendations'!$D12),0)

This does'nt, What is needed please
=IF($A45="COMMENDATION",SUM('Complaints and Commendations'!{"C12","D12"}),0)
Thankyou.

--

Dave Peterson

Shorten the formula
 

Why are you using SUM to get a single value?
=IF($A45="COMMENDATION",'Complaints and Commendations'!$C12),0)+
IF($A45="COMMENDATION",'Complaints and Commendations'!$D12),0)

So why not
=IF($A45="COMMENDATION",SUM('Complaints and Commendations'!$C12:D12),0)

OR
SUM('Complaints and Commendations'!$C12:D12)*($A45="COMMENDATION")

best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Steved" wrote in message
...
Hello from Steved

This works
=IF($A45="COMMENDATION",SUM('Complaints and
Commendations'!$C12),0)+IF($A45="COMMENDATION",SUM ('Complaints and
Commendations'!$D12),0)

This does'nt, What is needed please
=IF($A45="COMMENDATION",SUM('Complaints and
Commendations'!{"C12","D12"}),0)
Thankyou.

Shorten the formula
 

Thankyou.

"Dave Peterson" wrote:

=IF($A45="COMMENDATION",SUM('Complaints and Commendations'!$C12:$d12),0)

Steved wrote:

Hello from Steved

This works
=IF($A45="COMMENDATION",SUM('Complaints and
Commendations'!$C12),0)+IF($A45="COMMENDATION",SUM ('Complaints and
Commendations'!$D12),0)

This does'nt, What is needed please
=IF($A45="COMMENDATION",SUM('Complaints and Commendations'!{"C12","D12"}),0)
Thankyou.

--

Dave Peterson

Shorten the formula
 

Hello Bernard

It's one off those day's I just was'nt thinking

I Thankyou.

"Bernard Liengme" wrote:

Why are you using SUM to get a single value?
=IF($A45="COMMENDATION",'Complaints and Commendations'!$C12),0)+
IF($A45="COMMENDATION",'Complaints and Commendations'!$D12),0)

So why not
=IF($A45="COMMENDATION",SUM('Complaints and Commendations'!$C12:D12),0)

OR
SUM('Complaints and Commendations'!$C12:D12)*($A45="COMMENDATION")

best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Steved" wrote in message
...
Hello from Steved

This works
=IF($A45="COMMENDATION",SUM('Complaints and
Commendations'!$C12),0)+IF($A45="COMMENDATION",SUM ('Complaints and
Commendations'!$D12),0)

This does'nt, What is needed please
=IF($A45="COMMENDATION",SUM('Complaints and
Commendations'!{"C12","D12"}),0)
Thankyou.