=sumproduct(--(A1:A500<""),--(B1:B500<""),(A1:A500)+(B1:B500))

--
Regards,
Tom Ogilvy


"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