Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting characters in multiple rows when rows meet specific criteria
Hi can anyone help with what seems a simple task that I can't fathom. I want
to count characters in rows if the row starts with a certain inital in the first columb: a x x x b x x x x c x x x x x a x x x b x c x x x x x So what is the total number of "x" in rows begining with "b" I thought it would be simple but I cant work out can someone help at all, thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting characters in multiple rows when rows meet specific criteria
Assuming the data starts in A1, that the last possible column that can
contain data is K (just to have an ending column to refer to in the formula; change to suit your conditions) and the the maximum row where you could have data is 100 (again, change to suit your conditions)... =SUMPRODUCT((A1:A100="a")*(B1:K100="x")) Rick "news.virginmedia.com" wrote in message ... Hi can anyone help with what seems a simple task that I can't fathom. I want to count characters in rows if the row starts with a certain inital in the first columb: a x x x b x x x x c x x x x x a x x x b x c x x x x x So what is the total number of "x" in rows begining with "b" I thought it would be simple but I cant work out can someone help at all, thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting characters in multiple rows when rows meet specific criteria
So what is the total number of "x" in rows begining with "b"
5 =SUMPRODUCT((A1:A6="B")*(B1:F6="X")) -- Biff Microsoft Excel MVP "news.virginmedia.com" wrote in message ... Hi can anyone help with what seems a simple task that I can't fathom. I want to count characters in rows if the row starts with a certain inital in the first columb: a x x x b x x x x c x x x x x a x x x b x c x x x x x So what is the total number of "x" in rows begining with "b" I thought it would be simple but I cant work out can someone help at all, thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting characters in multiple rows when rows meet specific criteria
Thanks Rick and Biff very much appreciated
=SUMPRODUCT((A1:A100="a")*(B1:K100="x")) =SUMPRODUCT((A1:A6="B")*(B1:F6="X")) I can get on again now :) thanks "news.virginmedia.com" wrote in message ... Hi can anyone help with what seems a simple task that I can't fathom. I want to count characters in rows if the row starts with a certain inital in the first columb: a x x x b x x x x c x x x x x a x x x b x c x x x x x So what is the total number of "x" in rows begining with "b" I thought it would be simple but I cant work out can someone help at all, thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting Rows that meet criteria | Excel Worksheet Functions | |||
count rows that meet certain criteria | Excel Discussion (Misc queries) | |||
Delete rows that don't meet specific criterion | New Users to Excel | |||
Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions |