I have a countif on a number of names to be displayed in a cell i.e. =COUNTIF('Summary Matrix'!$K$3:$K$8,"James")
James = 10
Bob = 14
etc
I would like to do a count on 3 names in one cell. I.e. 10 instances of James + the 14 instances of Bob the cell would display 24.
However, I can't figure out how to do this. Anyone know?
depends on your version of excel and what your sheet looks like (easier to upload a book)
but you could just
or use sumproduct
Please Login or Register to view this content.
obviosly alter your ranges to suit
Last edited by twiggywales; 09-13-2012 at 06:25 AM.
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
sumproduct would be this for james and bob (take out the @ symbol see further in post for that)
then addPlease Login or Register to view this content.
where i put the @ symbol per namePlease Login or Register to view this content.
twiggywales,
Thanks that works like a charm. A follow up question though. I am dividing the names by the total number of records to give a %.
e.g. =COUNTIF('Summary Matrix'!$K$3:$K$8,"James")/957
/957 is the total number of names in the system
With additional CountIF statements this seems to be going a bit stange. If I remove the /957 I get the correct total count of the names. Do you know how I can convert this to a % ?
Put the countifs between brackets. Like this: (Countif1+Countif2)
=SUM(COUNTIF('Summary Matrix'!$K$3:$K$8,{"James","Bob","Ted}))/957
for instance
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks