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
Hi ladies! I am normally not on this board because I don't own too many gadgets and I'm afraid I'm not that "up" with technology so I feel very out of the loop. Anyway, would anyone be able to help me with this formula? I asked on my local board and 9 to 5 too.
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