Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct
Yes you should. But I'll take a guess that a bunch of blanks now meet the
criteria. After all, 0 is probably < Dashboard!AD3, and blank activity types also meet the < tests for each type of activity you're checking. So you may just need to put some kind of qualifier in there to check for a legit date (maybe even just 0). "Ken" wrote: A few days ago I received help with the following formula and it works fine =SUMPRODUCT(('DATA (RAW)'!BH2:BH5000DASHBOARD!AD3) *('DATA (RAW)'!N2:N5000<"SUPPORT REQUEST") *('DATA (RAW)'!N2:N5000<"WORK ORDER") *('DATA (RAW)'!AQ2:AQ5000<"EMEA") *('DATA (RAW)'!AQ2:AQ5000<"CALA") *('DATA (RAW)'!AQ2:AQ5000<"NA")) That said... when I try to use the same formula with the < it doesn't work. Should I not be able to do the following? =SUMPRODUCT(('DATA (RAW)'!BH2:BH5000<DASHBOARD!AD3) *('DATA (RAW)'!N2:N5000<"SUPPORT REQUEST") *('DATA (RAW)'!N2:N5000<"WORK ORDER") *('DATA (RAW)'!AQ2:AQ5000<"EMEA") *('DATA (RAW)'!AQ2:AQ5000<"CALA") *('DATA (RAW)'!AQ2:AQ5000<"NA")) Appreciate the help. Ken |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct
Thanks again ... that worked! Say is there anyway I can just download what
you know so I don't have to keep bothering you? This worked =SUMPRODUCT(('DATA (RAW)'!BH2:BH5000<DASHBOARD!AD3) *('DATA (RAW)'!N2:N5000<"SUPPORT REQUEST") *('DATA (RAW)'!N2:N5000<"WORK ORDER") *('DATA (RAW)'!AQ2:AQ5000<"CALA") *('DATA (RAW)'!AQ2:AQ5000<"ASIA") *('DATA (RAW)'!AQ2:AQ5000<"EMEA") *('DATA (RAW)'!AS2:AS5000<"CA") *('DATA (RAW)'!BH2:BH5000<0)) "bpeltzer" wrote: Yes you should. But I'll take a guess that a bunch of blanks now meet the criteria. After all, 0 is probably < Dashboard!AD3, and blank activity types also meet the < tests for each type of activity you're checking. So you may just need to put some kind of qualifier in there to check for a legit date (maybe even just 0). "Ken" wrote: A few days ago I received help with the following formula and it works fine =SUMPRODUCT(('DATA (RAW)'!BH2:BH5000DASHBOARD!AD3) *('DATA (RAW)'!N2:N5000<"SUPPORT REQUEST") *('DATA (RAW)'!N2:N5000<"WORK ORDER") *('DATA (RAW)'!AQ2:AQ5000<"EMEA") *('DATA (RAW)'!AQ2:AQ5000<"CALA") *('DATA (RAW)'!AQ2:AQ5000<"NA")) That said... when I try to use the same formula with the < it doesn't work. Should I not be able to do the following? =SUMPRODUCT(('DATA (RAW)'!BH2:BH5000<DASHBOARD!AD3) *('DATA (RAW)'!N2:N5000<"SUPPORT REQUEST") *('DATA (RAW)'!N2:N5000<"WORK ORDER") *('DATA (RAW)'!AQ2:AQ5000<"EMEA") *('DATA (RAW)'!AQ2:AQ5000<"CALA") *('DATA (RAW)'!AQ2:AQ5000<"NA")) Appreciate the help. Ken |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct using and, and or | Excel Discussion (Misc queries) | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Sumproduct(?) | Excel Discussion (Misc queries) | |||
Sumproduct with OR | Excel Worksheet Functions | |||
SUMPRODUCT | Excel Discussion (Misc queries) |