Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have this formula in columns of cells in 'sheet A'! D column, and the
result is various numbers, e.g. 1 thru 10 =IF(COUNTIF(MasterTab!$BH$21:$BH$917,G13)0,COUNTI F(MasterTab!$BH$21:$BH$917,G13),"") On the master tab, I also have column B that has various codes in some of the cells. And also, on the master tab, in column E, have numbers that may match the G13 in the above formula. I need a formula in the A column of sheet A, that has to count the number of times the letter u shows up in the 'master Tab'!B column when the 'master tab'!E column matches G13. If g13 in the above formula =158 So in the below, the result should be 3, which is the first um for 158, the second um for 158, and the last uc for 158. 3 times the u matches the 158's. B E uc 144 um 158 um 158 um 144 uc 158 I hope this makes sense ? Thanks, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Countif Use | Excel Worksheet Functions | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions |