How do I add all values in a given row (not colum)?

[Guest]

i am trying to search colum "A" for all values equal to something, say all
the cells that have '1000' as their data, and then add up all the cells in
the corresponding row, so if A34, A50, and A56 all have 1000 in them, then I
want to return the value of all the cells added up in the rows, say B34,50,56
: K34,50,56

 

[Guest]

Enter with Ctrl-Shift-Enter (an array formula)

=SUM(IF(A1:A100=1000,B1:K100))

Change range to suit

 

[VBA Noob]

Or how about

=SUMPRODUCT(--($A$1:$A$56=1000)*($A$1:$A$56)+(--($A$1:$A$56=1000)*($B$1:$B$56)+(--($A$1:$A$56=1000)*($K$1:$K$56)))

 

[Ragdyer]

What's wrong with simply using:

=SUMPRODUCT((A1:A100=1000)*B1:K100)

 

[VBA Noob]

Sorry I read it wrong

I thought he just wanted Col B and K not all of them

VBA Noo