Solved

Excell Summary Sheet (Number of and Lookup)

Posted on 2014-10-27
5
73 Views
Last Modified: 2014-10-28
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
Comment
Question by:Matt Pinkston
  • 3
  • 2
5 Comments
 
LVL 27

Accepted Solution

by:
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

by:ProfessorJimJam
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

by:ProfessorJimJam
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

by:Glenn Ray
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

by:ProfessorJimJam
ID: 40406977
:-)
0

Featured Post

ScreenConnect 6.0 Free Trial

Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
.Range Set 25 78
Excel 2016 vba task to have certain column appear in certain rows 20 27
Msgbox tickler 11 26
vba autofilter in row 4 6 11
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

810 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