Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Corporated into the same fromula please.
Hello from Steved
"11-190" is type of vehicle "11-190-12", "11-190-5", "11-190-6", "11-190-7" Can the above be incorporated into the formula below. =SUMPRODUCT(--($D$1:$D$798="City"),--(TRIM($C$1:$C$798)="11-190")) Thankyou. |
#2
|
|||
|
|||
Did you try with a tiny dataset for which the answer is easy to find?
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Steved" wrote in message ... Hello from Steved "11-190" is type of vehicle "11-190-12", "11-190-5", "11-190-6", "11-190-7" Can the above be incorporated into the formula below. =SUMPRODUCT(--($D$1:$D$798="City"),--(TRIM($C$1:$C$798)="11-190")) Thankyou. |
#3
|
|||
|
|||
Try this:
=SUMPRODUCT(($D$1:$D$798="City")*(TRIM($C$1:$C$798 )={"11-190-12","11-190-5", "11-190-6","11-190-7"})) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Steved" wrote in message ... Hello from Steved "11-190" is type of vehicle "11-190-12", "11-190-5", "11-190-6", "11-190-7" Can the above be incorporated into the formula below. =SUMPRODUCT(--($D$1:$D$798="City"),--(TRIM($C$1:$C$798)="11-190")) Thankyou. |
#4
|
|||
|
|||
Hi,
I hope i have uinderstood your question. Try this array formula (Ctrl+Shift+Enter) SUM(IF((A3:A6="City")*(ISNUMBER(FIND(A8,$B$3:$B$6) )),1,0)) A8 houses 11-190 $B$3:$B$6 houses "11-190-12", "11-190-5", "11-190-6", "11-190-7" Regards, Ashish Mathur "Steved" wrote: Hello from Steved "11-190" is type of vehicle "11-190-12", "11-190-5", "11-190-6", "11-190-7" Can the above be incorporated into the formula below. =SUMPRODUCT(--($D$1:$D$798="City"),--(TRIM($C$1:$C$798)="11-190")) Thankyou. |
#5
|
|||
|
|||
Hello from Steved
Thankyou. "Steved" wrote: Hello from Steved "11-190" is type of vehicle "11-190-12", "11-190-5", "11-190-6", "11-190-7" Can the above be incorporated into the formula below. =SUMPRODUCT(--($D$1:$D$798="City"),--(TRIM($C$1:$C$798)="11-190")) Thankyou. |
#6
|
|||
|
|||
=SUMPRODUCT(--($D$1:$D$798="City"),--(ISNUMBER(MATCH(TRIM($C$1:$C$798),{"11-190-12",
"11-190-5", "11-190-6", "11-190-7"},0))) Steved wrote: Hello from Steved "11-190" is type of vehicle "11-190-12", "11-190-5", "11-190-6", "11-190-7" Can the above be incorporated into the formula below. =SUMPRODUCT(--($D$1:$D$798="City"),--(TRIM($C$1:$C$798)="11-190")) Thankyou. -- [1] The SumProduct function should implicitly coerce the truth values to their Excel numeric equivalents. [2] The lookup functions should have an optional argument for the return value, defaulting to #N/A in its absence. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need a fromula | Excel Discussion (Misc queries) | |||
Fromula to take employee # out of employee name field | Excel Discussion (Misc queries) |