Thanks for your reply. I should have been more specific. What I want is to
count the cells in column A but I only want to count the cells in column A if
the same row has data in column B. My spreadsheet will have many rows of
data in column A but it will not have data in many of the rows of column B.
I am only interested in counting the rows in column if there is data in
column B.
--
Retired but Alive,

BigT


"Toppers" wrote:

By "something in column B" do you mean not blank or a specific value?

The formula below will count cells if A & B are non-blank (not empty).

=SUMPRODUCT((A2:A200"")*(B2:B200""))

Or

=SUMPRODUCT((A2:A200)*(B2:B200=condition))

HTH

"ThomH" wrote:

I have a large spread sheet and I need to count the cells with data in Column
A but only if there is also data in Column B. Can you help?
--
Retired but Alive,

BigT