| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple criteria for formulas
I am writing an excel program that refrences a wok sheet and i want to write
a countif A AND B type statement, how do i do this? ex: countif (cell reference X = 1) and (cell reference Y = 2) is there any way i can do this? Thanks! I've been trying to figure it out for months now! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
multiple criteria for formulas
=SUMPRODUCT(--(A2:A100=1),--(B2:B100=2))
-- Regards, Peo Sjoblom http://nwexcelsolutions.com "Jodi" wrote in message ... I am writing an excel program that refrences a wok sheet and i want to write a countif A AND B type statement, how do i do this? ex: countif (cell reference X = 1) and (cell reference Y = 2) is there any way i can do this? Thanks! I've been trying to figure it out for months now! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
multiple criteria for formulas
I don't want to sum the products of the two criteria, i only want excel to
recognize it if the two criteria are met. "Peo Sjoblom" wrote: =SUMPRODUCT(--(A2:A100=1),--(B2:B100=2)) -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Jodi" wrote in message ... I am writing an excel program that refrences a wok sheet and i want to write a countif A AND B type statement, how do i do this? ex: countif (cell reference X = 1) and (cell reference Y = 2) is there any way i can do this? Thanks! I've been trying to figure it out for months now! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
multiple criteria for formulas
=AND(A1=1,B1=2)
Biff "Jodi" wrote in message ... I don't want to sum the products of the two criteria, i only want excel to recognize it if the two criteria are met. "Peo Sjoblom" wrote: =SUMPRODUCT(--(A2:A100=1),--(B2:B100=2)) -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Jodi" wrote in message ... I am writing an excel program that refrences a wok sheet and i want to write a countif A AND B type statement, how do i do this? ex: countif (cell reference X = 1) and (cell reference Y = 2) is there any way i can do this? Thanks! I've been trying to figure it out for months now! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
multiple criteria for formulas
It doesn't sum it counts and since you mentioned COUNTIF it was quite
logical to assume you wanted to count, use the AND function -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Jodi" wrote in message ... I don't want to sum the products of the two criteria, i only want excel to recognize it if the two criteria are met. "Peo Sjoblom" wrote: =SUMPRODUCT(--(A2:A100=1),--(B2:B100=2)) -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Jodi" wrote in message ... I am writing an excel program that refrences a wok sheet and i want to write a countif A AND B type statement, how do i do this? ex: countif (cell reference X = 1) and (cell reference Y = 2) is there any way i can do this? Thanks! I've been trying to figure it out for months now! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return multiple rows of data based on criteria | Excel Worksheet Functions | |||
| Counting Using Multiple Criteria | Excel Worksheet Functions | |||
| Counting by multiple criteria | Excel Worksheet Functions | |||
| Multiple Criteria IF Nesting | Excel Worksheet Functions | |||
| Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
Linear Mode
