Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF THEN statements
I have 2 columns A & B. I want Xcel to first look at Column A and IF it
contains the number 1, then go to Column B and count how many A-1's there are. This is my formula - it's giving me a FALSE answer but I need a number. =IF($A$2:$A$174="1",COUNTIF($B$2:$B$174,"A-1") |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF THEN statements
Are you wanting to do a lookup for the number one in any cell n A???
=IF(ISERROR(VLOOKUP(1,A:A,1,0)),"",COUNTIF($B$2:$B $174,"A-1")) "perale" wrote: I have 2 columns A & B. I want Xcel to first look at Column A and IF it contains the number 1, then go to Column B and count how many A-1's there are. This is my formula - it's giving me a FALSE answer but I need a number. =IF($A$2:$A$174="1",COUNTIF($B$2:$B$174,"A-1") |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF THEN statements
Hi,
I'm not entirely sure I understand what you mean by A-1 and have assumed you mean text. =SUMPRODUCT((A2:A174=1)*(B2:B174="A-1")) Mike "perale" wrote: I have 2 columns A & B. I want Xcel to first look at Column A and IF it contains the number 1, then go to Column B and count how many A-1's there are. This is my formula - it's giving me a FALSE answer but I need a number. =IF($A$2:$A$174="1",COUNTIF($B$2:$B$174,"A-1") |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF THEN statements
Try this formula instead...
=SUMPRODUCT(($A2:$A$174=1)*($B$2:$B$174="A-1")) -- Rick (MVP - Excel) "perale" wrote in message ... I have 2 columns A & B. I want Xcel to first look at Column A and IF it contains the number 1, then go to Column B and count how many A-1's there are. This is my formula - it's giving me a FALSE answer but I need a number. =IF($A$2:$A$174="1",COUNTIF($B$2:$B$174,"A-1") |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF THEN statements
Try
=SUMPRODUCT(--($A$2:$A$174=1),--($B$2:$B$174="A-1")) That assumes that the values in column A are actual number, if they are text then =SUMPRODUCT(--($A$2:$A$174="1"),--($B$2:$B$174="A-1")) "perale" wrote: I have 2 columns A & B. I want Xcel to first look at Column A and IF it contains the number 1, then go to Column B and count how many A-1's there are. This is my formula - it's giving me a FALSE answer but I need a number. =IF($A$2:$A$174="1",COUNTIF($B$2:$B$174,"A-1") |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF THEN statements
Yes I am i.e. I have groups 1 - 13 listed in Column A. I want Xcel to go to
Column A, find any Group 1 and if that criteria exists, go to Column B and see if there are any A-1's and if there are give me a total of how many there are. In other words how many people in Group 1 fall in the A-1 category? "Sean Timmons" wrote: Are you wanting to do a lookup for the number one in any cell n A??? =IF(ISERROR(VLOOKUP(1,A:A,1,0)),"",COUNTIF($B$2:$B $174,"A-1")) "perale" wrote: I have 2 columns A & B. I want Xcel to first look at Column A and IF it contains the number 1, then go to Column B and count how many A-1's there are. This is my formula - it's giving me a FALSE answer but I need a number. =IF($A$2:$A$174="1",COUNTIF($B$2:$B$174,"A-1") |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF THEN statements
Thanks Rick. That worked.
"Rick Rothstein" wrote: Try this formula instead... =SUMPRODUCT(($A2:$A$174=1)*($B$2:$B$174="A-1")) -- Rick (MVP - Excel) "perale" wrote in message ... I have 2 columns A & B. I want Xcel to first look at Column A and IF it contains the number 1, then go to Column B and count how many A-1's there are. This is my formula - it's giving me a FALSE answer but I need a number. =IF($A$2:$A$174="1",COUNTIF($B$2:$B$174,"A-1") . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Statements | Excel Discussion (Misc queries) | |||
if then statements | Excel Worksheet Functions | |||
IF statements | New Users to Excel | |||
IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
using if statements | Excel Worksheet Functions |