A.png
I want to count the range(HX125:HX153) with 2 conditions:
1) count only if it has value including "0", so that cells with "-" are not count.
2) count only if the range(B125:B153) has string "*residential".
I tried to do it with SUMIF and COUNTIFS but my way is not working.
Please help. Thank you.
Bookmarks