You are reading a single comment by @hugo7 and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@hugo7
Excel question:
I need a cell to show:
X = 5% of Y where A is greater than zero. (A forms part of the calculation for Y).
...so in my head it needs to be something like:
=SUMIF(B1*0.05,A1>0)
[assuming A1 = A and B1 = Y]
...but it doesn't work. Any advice, or other search terms I should be using? I feel like I'm so close.