Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
counif by column2 & column 4 ?
Hello Experts
I think i may be using the wrong function but am at a loss to find a solution. Sheet scenario: Column2 Column4 Total example: apple green green apple =2 apple green red apple = 2 etc apple red apple red plum red plum pink banana yellow banana blue I need to get the Total for each fruit based on the color. I have the following code that counts each fruit successfully, all attempts to modify it to count based on col 4 fail. Is this possible? Many thanks. Dim iLoop As Integer Dim astrNames(3) As String Dim intCounter As Integer Dim strClient As String Dim strTotal As String 'store values to look for astrNames(0) = "apple" astrNames(1) = "orange" astrNames(2) = "plum" astrNames(3) = "banana" Range("L1").Select 'enter results here ' loop through array For intCounter = 0 To UBound(astrNames) iLoop = WorksheetFunction.CountIF(Columns(2), astrNames(intCounter)) 'countif for each name 'convert values to string strClient = CStr(astrNames(intCounter)) strTotal = CStr(iLoop) 'Enter value in column M ActiveCell.Value = strClient + " " + strTotal ActiveCell.Offset(1, 0).Range("A1").Select Next intCounter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column1 and Column2 | Excel Worksheet Functions | |||
Column1 and Column2 | Excel Worksheet Functions | |||
compare column1 with column2 | Excel Programming | |||
Counif | Excel Discussion (Misc queries) | |||
counif with two conditions | Excel Programming |