Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountIf or sumproduct
I need a countif or sumproduct formula that can count a number of values
based on a multiple criteria. Count range: D:D column Criteria: Count the number of cells that are greater than 0 and less than 200 in column H:H, that also have a the word "BUY" in coulmn B:B. Any help would be appreciated. -- Regards, timmulla |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountIf or sumproduct
Unless you're using XL07, you can't use entire rows (B:B, H:H) in your
SumProduct formula. Try this: =SUMPRODUCT((B1:B1000="Buy")*(H1:H10000)*(H1:H100 0<200)*(D1:D1000<"")) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "timmulla" wrote in message ... I need a countif or sumproduct formula that can count a number of values based on a multiple criteria. Count range: D:D column Criteria: Count the number of cells that are greater than 0 and less than 200 in column H:H, that also have a the word "BUY" in coulmn B:B. Any help would be appreciated. -- Regards, timmulla |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT, COUNTIF and wildcard | Excel Worksheet Functions | |||
sumproduct vs. countif | Excel Discussion (Misc queries) | |||
countif more than one sheet/tab and sumproduct | Excel Worksheet Functions | |||
countif, sumproduct | New Users to Excel | |||
Using COUNTIF with 2 criteria - SUMPRODUCT? | Excel Worksheet Functions |