Solved

Conditional Summation in Excel

Posted on 2013-06-28
2
188 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 500 total points
ID: 39284012
Try:

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

Expert Comment

by:itjockey
ID: 39287144
Hi shaunwingin,


Try Attached File,


Thanks
Sum.xlsx
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

747 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now