Previous Topic Next Topic

Need help with a formula

Closed
Helpplease - 8 Oct 2009 à 22:14
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 8 Oct 2009 à 22:20
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

Réponse 1 / 1
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
8 Oct 2009 à 22:20
=SUMPRODUCT(($B$1:$B$3=0)*($C$1:$C$3))

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

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