Try this:

=SUMPRODUCT((MOD(COLUMN(B1:E5),2)=0)*(B1:E5=3)*A1: A5)

Adjust ranges to suit.

As written, it tests B1:B5 and D1:D5 for the number 3.

--
Biff
Microsoft Excel MVP


"Nick" wrote in message
...
Sorry guys that was an exapmle out of another spreadsheet. I want to find
the
number "3" in every other column in my spreadsheet starting with coulumn
"b",
add the count of occurences in a given row and multiply by the length in
column A, and recieve a total for all rows. Does that help?

"Dave Curtis" wrote:

It's difficult to determine your data layout.
What are the references to columns J, L, M and P in your formula?

Dave

url:http://www.ureader.com/msg/104233407.aspx