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. |
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. |
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. |
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. |
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. |
=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. |
All times are GMT +1. The time now is 10:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com