Previous Topic Next Topic

Need help with a formula

Closed
Helpplease - Oct 8, 2009 at 10:14 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 8, 2009 at 10:20 PM
I want a formula that will search column B for zeroes. When it finds one, I want it to look to the neighboring cell in column C, take that value and add it, and continue to look for more zeroes in column B.

Example:
B C
1 1
0 2
0 1


Result: 3

Can anyone help? Thank you very much!

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Oct 8, 2009 at 10:20 PM
=SUMPRODUCT(($B$1:$B$3=0)*($C$1:$C$3))

change B3 and C3 to values those suit you like B100 and C100
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response