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.
Sam_w
@hugo7
Recovering from a sever case of manflu and can't for the life of me work out how to do this:
e.g. add all cells in B2:B100 where corresponding cell in E# = "fruit"
Sorry if that makes no sense!
EDIT:
What was trying to do is:
=sumif(F2:F200,"=cell#",D2:D200)
...but had the F and D cells the wrong way round :S