Gadgets & Technology
Dear Community,

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 [email protected]

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!

~Bonnie
Visit The Nest!

Re: Excel Help - IF function

  • I should be able to write this formula for you.  You're going to need the "COUNTIF" function.  Can you PM me for contact info and provide me with a dummy/example spreadsheet?  It would be easier than me typing out the explanation.  But yeah, I think I get what you mean.
    image Daisypath Anniversary tickers
Sign In or Register to comment.
Choose Another Board
Search Boards