Counting how many live product per post code. Countifs function??

[MHERSI]

Hi Guys

I am looking for a formula that works out how many products live and dead on a post code - see example attached

I guess this calls for countifs function, but I can't get it right. Your support is very much appreciated

Many Thanks
MH Hersi

[Sam Capricci]

You might want to try this in E2... =COUNTIFS($L$2:$L$17,$B2,$J$2:$J$17,TRIM(E$1)), you can drag it right and down.
you have an extra space in E2 that isn't in J16 or J17. If you remove the spaces in E2 and F2 you can drop the trim function.

that is why your countifs function was likely returning 0. try =E2=J16 and you'll see it returns false.
try =Len(e2) and it will return 5 while =LEN(J16) will return 4.

[MHERSI]

Excellent this has worked. Thank you very much indeed