S
Steved
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.
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.