array count

I think I need an array formula for the following calculation. <tbody> A B C D E Colour Size Countif1 Countif4 If, Sumproduct(Size, Count) 1 Red 5 1 n/a =5*1 + 6*2 + 4*3 2 Pink 4 1 n/a 3 Blue 2 1 n/a 4 Red 6 2 1 =6*1 + 4*2 5 Red 4 3...

Hi there! (I am using Excel 2010) I have a workbook containing several worksheets. Many of the worksheets in the workbook have similar names: for example, "125005A," "125005B," "125005C," "120320A", "120320B," "130211A," "123456A," "123456B," "123456C," "123456D," and "123456E" are all in the...

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...

Hey guys, I have a variable length array in VBA whose number of elements will change with usage. For example: [ Apple, Orange, Banana, Banana, Apple, Banana ]I would like to count the number of occurances of each element within the array and then return both the element and its count in a...

Dear All, I am looking for an array formula to return the number of times in a list of records that two fields within each record are equal. For example: Column A is the field "Beginning". Column B is the field "Ending". On each line, either the values in columns A and B are equal or they...