| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif 2 criteria
Hi
Struggling to get this to work, despite looking at the treads. Using excel 2003. trying to count how many times 5710 in col G has "6" in Col H col-G col-H 5710 --- 7 5710 ----6 5694 ----6 5678----3 5710 ---6 =SUMPRODUCT(--(G2:G6=5710),--(H2:H6=6)) Would like to add 5694 as well as 5710, is this possible and does if have to be on the same sheet? thanks in advance brian -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/201003/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF criteria | Excel Worksheet Functions | |||
| COUNTIF with various criteria | Excel Discussion (Misc queries) | |||
| countif criteria | Excel Worksheet Functions | |||
| Countif using format criteria not number criteria? | Excel Worksheet Functions | |||
| Countif using format criteria....not number criteria? | Excel Worksheet Functions | |||
Threaded Mode
