Thread: [Solved] Conditional calculations
View Single Post
 
Old 12-30-2017, 08:24 AM
LearnerExcel LearnerExcel is offline Windows 7 32bit Office 2003
Advanced Beginner
 
Join Date: Nov 2016
Posts: 82
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default Conditional calculations

How can I write a conditional SUM formula to get these totals.

If A2 has some value then it should SUM the values as =SUM(A2*C2) if A2 has "0" then
it should calculate SUM as =SUM(B2*C2).

What is the code for this one, please.
Attached Images
File Type: png If Calculation.PNG (5.9 KB, 27 views)
Reply With Quote