NY2DR
04-01-2008, 10:51 AM
Hello all,
Need help with counting and suming
I understand this part:
=COUNTIF(List!$L:$L,"*"&$A2&"*")
This uses a CONCATENATE and wildcard. It works very well
I also undersatnd this part:
{=SUM(IF(List!E1:E1500=$B1,1))}
This will count full matching text
This even works well if I want to count 2 criterias:
{=SUM(IF((List!L1:L1500=A2)*(List!E1:E1500=B1),1))}
But can I do something like this; count a full text and the other with a CONCATENATE and wildcard?
{=SUM(IF((List!L1:L1500="*"&$A2&"*")*(List!E1:E1500=B1),1))}
This does not work at all!
How could I make this work?
Thanks
Need help with counting and suming
I understand this part:
=COUNTIF(List!$L:$L,"*"&$A2&"*")
This uses a CONCATENATE and wildcard. It works very well
I also undersatnd this part:
{=SUM(IF(List!E1:E1500=$B1,1))}
This will count full matching text
This even works well if I want to count 2 criterias:
{=SUM(IF((List!L1:L1500=A2)*(List!E1:E1500=B1),1))}
But can I do something like this; count a full text and the other with a CONCATENATE and wildcard?
{=SUM(IF((List!L1:L1500="*"&$A2&"*")*(List!E1:E1500=B1),1))}
This does not work at all!
How could I make this work?
Thanks