Solved

# Excell Summary Sheet (Number of and Lookup)

Posted on 2014-10-27
69 Views
I have an excel spreadsheet with multiple tabs

Summary
XXX Detail
Missing

I need a formula for Summary B5 that will be the number of records from XXX Detail where column F begins with 01 and column M = WIN and column C = Civilian

I also need a formula for Summary T5 that will be the number of records from Missing where column H = Civilian and column J begins with 01
0
Question by:Matt Pinkston
• 3
• 2

LVL 27

Accepted Solution

Glenn Ray earned 500 total points
ID: 40406936
Summary Sheet:
B5: =COUNTIFS('XXX Detail'!F:F,"01*",'XXX Detail'!M:M,"WIN",'XXX Detail'!C:C,"Civilian")

T5: =COUNTIFS(Missing!H:H,"Civilian",Missing!J:J,"01*")

Regards,
-Glenn
0

LVL 25

Expert Comment

ID: 40406954
HERE YOU GO

B5=COUNTIFS('XXX Detail'!F:F,"01*",'XXX Detail'!M:M,"WIN",'XXX Detail'!C:C,"Civilian")
T5==COUNTIFS(Missing!J:J,"01*",Missing!h:H,"Civilian")
0

LVL 25

Expert Comment

ID: 40406962
oh come on  Glenn. :-)

you are always ahead of me.  if you i knew that you are working on it, i wouldn't have wasted time :-)
0

LVL 27

Expert Comment

ID: 40406973
Sorry. :-)  I try to remember to refresh the browser before I post 'cuz it happens to me, too.
0

LVL 25

Expert Comment

ID: 40406977
:-)
0

## Featured Post

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…