A arif Member Mar 18, 2016 #1 i have attached a file that requires to put sum total as per condition can you check and plz revert the best sirs ? Attachments sumiforfurmula.xlsx sumiforfurmula.xlsx 8.4 KB · Views: 6
i have attached a file that requires to put sum total as per condition can you check and plz revert the best sirs ?
Luke M Excel Ninja Staff member Mar 18, 2016 #2 Formula would be something like: =SUMIF(A5:A13,5,B5:B13) Change the middle argument to whatever you want, or make it a cell reference for easier use. Attachments sumiforfurmula LM.xlsx sumiforfurmula LM.xlsx 9.4 KB · Views: 2
Formula would be something like: =SUMIF(A5:A13,5,B5:B13) Change the middle argument to whatever you want, or make it a cell reference for easier use.
skyh3ck Member Mar 18, 2016 #3 =IF(A5=5,A5+B5,"") - for value 5 =IF(A5=7,A5+B5,"") - for value 7 Attachments sumiforfurmula.xlsx sumiforfurmula.xlsx 9.4 KB · Views: 4
