count combinations

Hello I am pretty new to excel and was hoping someone could help with this. I have two columns Column A Has grouped Names and Column B has kinds of Relationships I need to count all the kinds of Relationships: Self, Boss, Peer, Direct Report, Other for each Name in column A I can count ALL...

I'm trying to come up with a count formula to meet my needs. I want the formula to count each row in a sheet that meets two requirements. A cell in a certain column contains a specific text. A cell in a certain column falls within a specific month, the cell is currently in the mm/dd/yyyy...

Hello everyone! Suppose I have the following range: <tbody> Project Name Color Project A yellow Project A green Project A red Project A green Project A green Project B blue Project B yellow Project B yellow Project B blue </tbody> I would like to code a custom function...

Dear Experts, Note: I'm using Excel 97. That's right. I have a huge set of data with a wide range of values. About 800 rows. One column. 0 1 24 56 75 2 8 45678 2 98 33356 32 etc. I'd like to make the table that you need to make the histogram. With counts in the appropriate cells...

I everyone, I am new to using Excel to this level and I am trying to do a complex count where there are a combination of AND and OR criteria. I have managed similar things by using =count(if( and entering the formula as an array, however, this particular scenario seems to have too many...

I have a table showing examination lists for a total of 295 students taking up to 6 exam papers. Example: <TABLE style="WIDTH: 192pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=256><COLGROUP><COL style="WIDTH: 48pt" span=4 width=64><TBODY><TR style="HEIGHT: 15pt"...