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!