Which formula did you use?

Post the exact formula you tried.

Biff

"Aaron Saulisberry" wrote in
message ...
Well I hit the reply button to soon...

The formula does work but it returns the count of how many matches there
are
rather than the total value of the columns that match. As always, help is
greatly appreciated.

"Biff" wrote:

Hi!

Try this:

=SUMPRODUCT((A1:A10<"")*(B1:B10<"")*A1:B10)

Biff

"Aaron Saulisberry" wrote in
message ...
What I'd like to to is the following.

I have many rows, some with data in column A and some with data in
column
B.
I'd like to do is if there is data in BOTH column A AND B for the same
row
to
toltal those figures for the entire sheet.

I'm not sure how to write the formula to validate that there is both
data
in
column A AND column B. Any help is appreciated