Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shorten a formula | Excel Discussion (Misc queries) | |||
Shorten a formula | Excel Discussion (Misc queries) | |||
Shorten a Formula | Excel Worksheet Functions | |||
Shorten an IF formula | Excel Discussion (Misc queries) | |||
Trying to shorten (or use new) formula | Excel Discussion (Misc queries) |