Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count cells that meet 2 criteria
What formula should I use to count how many cells in columns G,I,K,M contain 8-May and how many cells in columns H,J,L,N contain Passed (for example)? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count cells that meet 2 criteria
=SUMPRODUCT((MOD(COLUMN(G2:M20)-COLUMN(G2),2)=0)*(G2:M20=--"2008-05-08")*(H2:N20="Passed"))
-- __________________________________ HTH Bob "aimee" wrote in message ... What formula should I use to count how many cells in columns G,I,K,M contain 8-May and how many cells in columns H,J,L,N contain Passed (for example)? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count cells that meet 2 criteria
On Jun 18, 5:41 am, "Bob Phillips" wrote:
=SUMPRODUCT((MOD(COLUMN(G2:M20)-COLUMN(G2),2)=0)*(G2:M20=--"2008-05-08")*(H2:N20="Passed")) -- __________________________________ HTH Bob "aimee" wrote in message ... What formula should I use to count how many cells in columns G,I,K,M contain 8-May and how many cells in columns H,J,L,N contain Passed (for example)? Hey, Bob. Can you explain what your first argument is doing in that formula? I don't mean to hijack, but maybe this would help the OP, too. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count cells that meet 2 criteria
Because the data is offset, the first column has one set of data, the second
has another, that first test is to do an '... every other column' test (note how the second range is offset at start and end by one column. Although it may be overkill, the simpler formula =SUMPRODUCT((G2:M20=--"2008-05-08")*(H2:N20="Passed")) could allow a situation whereby say H8 had a date of th May and I8 had Passed to be counted, which against the OPs rules. -- __________________________________ HTH Bob "Spiky" wrote in message ... On Jun 18, 5:41 am, "Bob Phillips" wrote: =SUMPRODUCT((MOD(COLUMN(G2:M20)-COLUMN(G2),2)=0)*(G2:M20=--"2008-05-08")*(H2:N20="Passed")) -- __________________________________ HTH Bob "aimee" wrote in message ... What formula should I use to count how many cells in columns G,I,K,M contain 8-May and how many cells in columns H,J,L,N contain Passed (for example)? Hey, Bob. Can you explain what your first argument is doing in that formula? I don't mean to hijack, but maybe this would help the OP, too. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count rows that meet certain criteria | Excel Discussion (Misc queries) | |||
Count Cells that meet Criteria | Excel Worksheet Functions | |||
How do I count nonblank cells that meet criteria in another cell? | Excel Worksheet Functions | |||
count non blank cells which meet criteria in another column | Excel Worksheet Functions | |||
How can I count cells that meet two criteria within a filtered co. | Excel Worksheet Functions |