Our tech team has launched updates to The Nest today. As a result of these updates, members of the Nest Community will need to change their password in order to continue participating in the community. In addition, The Nest community member's avatars will be replaced with generic default avatars. If you wish to revert to your original avatar, you will need to re-upload it via The Nest.
If you have questions about this, please email help@theknot.com.
Thank you.
Note: This only affects The Nest's community members and will not affect members on The Bump or The Knot.
Excel Help - IF function
Lurker, first time poster -
I have a workbook with multiple worksheets. Sheet 1 is my "master" slide and each sheet after it are my "sub" sheets that I use to track sales for each region.
I want a formula on my master to show me the actual number of sales we have in total. I want to create a formula that says something like - if there is anything (a name of a business) in this cell then count it as 1 and then give me a running total on my master slide.
I want to do this again but by using the word "yes".
Then I want to be able to subtract the total number of sales with the number of "yes" to give me a total. (I can certainly handle this formula unless I will have to do something different than the normal "=D9-E9")
Would it just be easier to add a column to each sheet where I put the #1 and then just put in a sum formula? I would like to avoid doing that because I feel like the IF formula could be easier.
Thank you in advance!
Re: Excel Help - IF function
I'm not sure I fully understand what you are trying to count. This probably isn't exactly what you are looking for, so in this example I'm saying you want to count X number of businesses, and how many of those some criteria that equals a "yes."
For example,
Company X = $50 = yes
Company Y = $100 = yes
Company Z = $0 = no
You want to know that there are three companies, so using COUNTA, you'd put on your master sheet =COUNTA(Sheet2!B1:B23), and it will give you a number corresponding to all the non-blank cells, or in my example, 3.
For counting the "yes" cells, you probably want something like =COUNTIF(Sheet2!C1:C23, "yes"), which in my example returns 2.
On your master sheet you should then be able to just subtract the cells for the first and second formulas, which shows you have one company that didn't make a sale.
I haven't been on here for too long myself, but this is my kind of question! All day every day I live in Excel and you will find that it can do nearly anything you want! Google what you want to do and it should bring up many options for you.
The other responses have this covered and should get the result you want. You can remember it by the "COUNT" function as only dealing with numbers, where the "COUNTIF" function can do numbers and others (letters and words).
Happy Excel-ing!