Search results

Wow. Amazing!! Thank you Luke.. it works like a treat!! Amazing stuff! bobhc - sorry. I was not trying to waste anyone's time. I really appreciate Luke's time and effort, and I really hope that his solution will help many others in similar scenarios.

thank you Luke How about this? type £ Code Crit. Formula Result R1 6562 AR Cash P Cheque, DD 28783 R2 8502 Cash B DD 18737 R3 3673 DD P RR, Cash, DD 51071 R4 8420 DD B RR 16690 R5 5975 RR Cheque C...

Excellent. Thank you so much Luke! And add-in to that question That works great is what you are looking for the exact value, A's and/or B's What is the code column would have now types of transaction and your criteria would look at whether it is part of the type or not something like...

Actually that kind of works. Thank you Luke However i would need to change the Criteriacell each time. Imagine criteria column like this Criteria {"A","B"} {"A","G","H"} what I want is to use your formula that change the criteria cell as you copy down so, 1)...

I forgot to mention that if the criteria cell says: A, B I am using a concatenate to make it a selection, something like ="{"&B12&"}" where B12= "A","B"

HI Hui Thanks a lot for your fast reply, although it is not really what I am after. I guess I explained it wrong. The criteria column is dinamic, I can not define Criteria as a static range, otherwise I have to retype it for each of the criterias which could be as many as N. The criteria...

Hi all A tricky one that I could not crack this morning. Say that you have this list: type £ Code R1 6562 A R2 8502 B R3 3673 C R4 8420 B R5 5975 A R6 3457 G R6A 7224 H R6B 7258 J and you want to sumif, column 2 if the criteria for column 3 is {A,B} now you can do that if you use...

{=SUM(IF(COUNTIF($A$1:$A$135,$A$1:$A$135)=1,1,0))} (array formula) this should work. Result = 4