Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can countif function look at 2 separate columns for criteria
I want to use the countif function in excel to look at one criteria in one
column and another criteria in another before summing up, can this be done ? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can countif function look at 2 separate columns for criteria
No but you can use SUMPRODUCT,
assume you want to count values in A1: A10 that are greater than 5 and has the colour red in B1: B10 =SUMPRODUCT(--(A1:A105),--(B1:B10="red")) -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "blake7" wrote in message ... I want to use the countif function in excel to look at one criteria in one column and another criteria in another before summing up, can this be done ? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can countif function look at 2 separate columns for criteria
try to use the following array function:
(array function end with Ctrl+Shift+Enter) =COUNT(IF((($A$2:$A$8)="A")*(($B$2:$B$8)="A"),$C$2 :$C$8)) -- Best regards, --- Yongjun CHEN XLDataSoft - Data Analysis Expert, Excel/VBA Specialist - - - - www.XLDataSoft.com - - - - Free Excel-Based Data Processing Tool is Available for Download "blake7" wrote in message ... I want to use the countif function in excel to look at one criteria in one column and another criteria in another before summing up, can this be done ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
CountIf Function Help Needed | Excel Worksheet Functions | |||
Separate address column to Five columns | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) |