Conditional Row Value In A Multiple Rangs

Hello,

How can I do the following for values in a range.
Count if A1 = value 1, B1= blank, C1 = blank1, D1= blank, E1 = blank1, F1= blank

One way - that I would rather not use - is to drag the formula so it applies to every entry in the range, then do a count of the true value. Given the work that I am doing, that would be very impractical. I am simply looking for one formula, in one cell that would do the conditional if count across a range. The condition applies to cells in a row in the ranges.

Using VA and macros are out of the question.

Thanks.

=sumproduct((a1:a500<>"")*(b1:b500="")*(c1:c500="")*(d1:d500="")*(e1:e500="")*(f1:f500=""))

In theory you could also concatenate B:F and test as one string:

=SUMPRODUCT(--(A1:A500<>""),--(B1:B500&C1:C500&D1:D500&E1:E500=""))

assuming this is what you want to do of course...