Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula help
A B
1 1 a7 2 2 a6 3 3 a6 4 3 a4 I would like a formula that counts how many times A:A =3 and B:B =a6 In this example, the answer is 1 THANK YOU |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula help
Sumproduct would be what you want, unfortunately it doesn't except entire
columns as input so you have to do something like the following: =SUMPRODUCT(--(A1:A65535=3),--(B1:B65535="a6")) + SUMPRODUCT(--(A65536=3),--(B65536="a6")) -- Regards, Dave "TMF in MN" wrote: A B 1 1 a7 2 2 a6 3 3 a6 4 3 a4 I would like a formula that counts how many times A:A =3 and B:B =a6 In this example, the answer is 1 THANK YOU |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |