Home |
Search |
Today's Posts |
#1
|
|||
|
|||
COUNTIF Statement with Multiple Conditions in Different Ranges
I'd like to count the number of values whe
Column A equals X AND Column B equals y (for any given row) Is this possible? |
#2
|
|||
|
|||
Hi
You'll need to use SUMPRODUCT() for this. eg: =SUMPRODUCT((A2:A1000="X")*(B2:B1000="Y")) You cannot use full column references eg A:A and the references you do use must be the same size. -- Andy. "KJA" wrote in message ... I'd like to count the number of values whe Column A equals X AND Column B equals y (for any given row) Is this possible? |
#3
|
|||
|
|||
and for details on how the SUMPRODUCT function works check out
http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway <Andy B wrote in message ... Hi You'll need to use SUMPRODUCT() for this. eg: =SUMPRODUCT((A2:A1000="X")*(B2:B1000="Y")) You cannot use full column references eg A:A and the references you do use must be the same size. -- Andy. "KJA" wrote in message ... I'd like to count the number of values whe Column A equals X AND Column B equals y (for any given row) Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup with multiple conditions | Excel Worksheet Functions | |||
SUM based on multiple conditions - SORRY, URGENT!!! | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
COUNTIF using multiple conditions? | New Users to Excel | |||
Count If Formula for multiple conditions?? How To?? | Excel Worksheet Functions |