Hi guys, Honestly didn't know how to word the title.
So how would i go about doing this..
Will have an outcome of 22, then this to be in the same formula
Please Login or Register to view this content.
=SUM(H5) Was linked to the outcome of the vlookup above(22).Please Login or Register to view this content.
Which will minus how many times 'H' appears and take it away from the 22
Any ideas?
Are you asking a question or just telling us what you did? What is it that you aim to do but cannot?
Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.
"I am here to help, not do it for people" -Me
Oh sorry, Combine them formula's into one.. if possible?
Try this:
=IFERROR(VLOOKUP(H1,REGISTER,8,0),0)-COUNTIF(H397:H762,"H")
If that doesn't do what you are expecting, consider uploading a small representative sample along with the desired results based on that sample.
Worked perfectly, thanks
You may want to consider a SUMIF or SUMIFS, use the same criteria you use for VLOOKUP for the SUMIF/SUMIFS instead.
So you would end up with a SUMIF-COUNTIF or a SUMIFS-COUNTIF
You're welcome. Happy to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks