This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
So my formula for Cash Flow was working great until I decided to add in varying unit sizes. I thought that if I used a vlookup and referenced the units with the table on the right it would work out but the unit sizes don't impact it at all and I am left with the same result I had before adding in the units and vlookup. As you can see at the top, the formula basically states that if there is any text in the result column, then it will give a negative unit for every time there is one. That is then added by the collect value in the table whenever a "Win" value is given in the result column. I'm just looking for any way to have the units be factored in. Any and all responses will be greatly appreciated thanks guys.
Also for reference this was my formula before trying vlookup and calculating units.
=(-COUNTIF(F4:F995,"*")*M10)+O10*COUNTIF(F4:F995,"Win")
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
G4: =IF(F4="",0,IFERROR(VLOOKUP(E4,$L$10:$M$13,2,0),0))
drag down
K3: =SUM(G:G)+O10*COUNTIF(F:F,"Win")
Andreas.
Hello, Nicholas
Have your referred to the reply shared by Andreas?
If you need any further help, please feel free to post back to us.
Regards,
Igor