Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif2
Have 10 columns and 30+ rows. Various placements of "x" in this range. Need
formula that will result in denoting that if based upon a row whether 1 "x" or numerous "x" are placed on that row. In otherwards If 1 "x" or numerous "x" in a row give me a value of 1 for that row but will sum up the different rows if statement is met. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif2
Huh?
I guess this is related to your other post. Based on your other post... To sum the values in column J where there are 2 or more X's on the same row. Try this array formula**: =SUMPRODUCT(--(MMULT(--(A1:H30="X"),TRANSPOSE(COLUMN(A1:H30)^0))=2),J1:J 30) -- Biff Microsoft Excel MVP "Gordy" wrote in message ... Have 10 columns and 30+ rows. Various placements of "x" in this range. Need formula that will result in denoting that if based upon a row whether 1 "x" or numerous "x" are placed on that row. In otherwards If 1 "x" or numerous "x" in a row give me a value of 1 for that row but will sum up the different rows if statement is met. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|