Hi guys,
I could use some help with a nested IF function. Link to the spreadsheet: https://docs.google.com/spreadsheet/...FE&usp=sharing
Please feel free to have a look, (Navigate to the "Signerte Q4" pane)
I have two issues:
1. I am trying to count the number of "Ja" in K7:V7 and come out with a percentage of "ja" to C7. So far i got this: =countif(K7:V7, "Ja")/counta(K7:V7) however this returns an error.
2. I am trying to estimate revenue from our clients based on what we provide them with. J7 is the total pot of revenue and in the area K7:V7 is our products and an estimate of what percentage of the revenue the client spends on this product - we get a 5% commision on this sum.
Example: If K7=Ja, then (22505000(J7)*0,3(L7))*0,05 and i want to extend this for all of K7:V7) and return it to D7.
Would greatly appreciate any assitance with this!
Bookmarks