» Summing How Many Points Scored by a Specified Team in Specified Games
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Listed in columns A:C are the point totals scored by teams A and B in the first four games of the season.
We want to calculate the total number of points scored by Team B in the first two games.
Solution:
Use the SUM function in the following Array formula:
{=SUM((A2:A9=""B"")*(B2:B9<=2)*C2:C9)}
Example:
Team____Game #___Points
A_______1________15
B_______1________10
A_______2________20
B_______2________13
A_______3________9
B_______3________14
A_______4________15
B_______4________13
Result 23
Book Store:
Recommended Books:
- Finance and Accounting for Nonfinancial Managers
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
Blinking in field
Rajesh Shah
I would like to have some Text shoud be blinking in the cell. How to do ?
Reply: Rajesh Shah
Alan
Hi Rajesh,
[QUOTE=Rajesh Shah]I would like to have some Text shoud be blinking in the cell. How to do ?[/QUOTE]The only way to do that is to use VBA.
Post back if that is a viable option for you and you need help to do it, but I would seriously consider how much you really need to do it, especially if you don't already have code in the workbook in question.
Alan.
texas holdem
texas holdem
sort
asif
How do I sort a column which is a result of averaging over other columns. The sort does not work with formulas.
Also, how can i tell how many cells are above a certain value without sorting.
