Hi all I'm Stuck.
I need t calculate an admin fee of £3.35 for each employee worked in a week. however i do not want to enter the calculation manually e.g =4*3.35. i have attatched a mock sheet of what the sheet looks like.
Many Thanks
Deano3141
WORKING SHEET.xlsx
Hi there,
You can use COUNTIF in cell C13 and drag to the right:
Formula:
Please Login or Register to view this content.
Hope it helps
Regards
Miroslav R.
(If You like my solutions, feel free to add reputation.)
Use,and copy right for all quartersFormula:Please Login or Register to view this content.
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
thank you it worked. although you put a semicolon in instead of a comma.
=COUNTIF(C$3:C$10;">0")*3.35
=COUNTIF(C$3:C$10,">0")*3.35
Yop... depends on You country&version set-up...
Glad that I could help!
That is due to different regional settings in excel. Mine uses ; here as well. I just manually change it to , when posting solutions.
It is difficult for me to remember what countries use what anymore.
Despite the high cost of living, it remains very popular.
Don't forget to mark threads SOLVED when you get an answer and rep all the geniouses that helped you today!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks