Count value only if it meets a size in column a and has positive value in column b

[THEKATSTERS]

I need to count only vacant units by size that have a deposit on them.

I have figured already
=COUNTIF(VCR!B6:B26, "1X1") is how I determine how many vacant units I have of this size type.
but I can not figure how to count only if
(VCR!K6:K26) is not blank

I looked at the forums and came up with this, but it is still not giving me a true count

=COUNT(IF(VCR!B6:B26,"2X2")*IF(VCR!K6:K26=1,1,0))

[FDibbins]

Hi and welcome to the forum

Try looking at using the countifS() function, it allows more than 1 criteria...
=COUNTIFS(VCR!B6:B26, "1X1",VCR!K6:K26,"<>""")

[THEKATSTERS]

Thank you, that was very helpful. I wasn't able to use the formula exactly but it was easy to modify to my needs.
I just had to remove a couple " and adjust <>

=COUNTIFS(VCR!B6:B26, "1X1",VCR!K6:K26,">0")

Thank you again!

[FDibbins]

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)