Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Conditional Summation in Excel

Posted on 2013-06-28
2
Medium Priority
?
236 Views
Last Modified: 2013-06-29
Hi

Say,

Column A has a 1 or 0 - Column G has figures which i wish to sum in column H if there is a 1 in column A. Please can you assist a novice on how to implement this?
0
Comment
Question by:shaunwingin
2 Comments
 
LVL 23

Accepted Solution

by:
NBVC earned 2000 total points
ID: 39284012
Try:

=Sumif(A:A,1,G:G)
0
 
LVL 8

Expert Comment

by:Naresh Patel
ID: 39287144
Hi shaunwingin,


Try Attached File,


Thanks
Sum.xlsx
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question