osx - adding and subtracting cells in excel -

-

say have 7 groups of columns of 2 columns , each group of column represent 1 day " monday tuesdays ect... & in 1 group of columns there's either "win" or "lost" want add columns win add , lost subtract automatically. have set can 1 "win" or 1 "lost" in each group of 2 columns. exp: {a(win) b(lost)} {c(win) d(lost)}

so want if "a" win , " c" win , "f" lost , "h" lost , "i" win ect... come total

exp: a[1234] +c[1234] - f[1234] -h[1234] = [total]

i want lose shown in negative ...

how can make whole column show has negative value everytime enter number : -1234 if enter 1234 in "lose" column

if want sum number of wins , loses can use countif on ranges care about, e.g.

=countif(b4:b13,"win") -countif(b4:b13,"loss")

you'll need change b4:b13 ranges match wherever tracking wins/loses , change "win" , "loss" strings match whatever indicates whether given day win or loss. if want apply different scoring wins vs. losses multiply countif statements scoring values.


Comments

Post a Comment

Popular posts from this blog

Unable to remove the www from url on https using .htaccess -

-
i want remove www site url. ie. https://www.domainname.com.au https://domainname.com.au . i have tried various .htacces code nothing work me. here present code remove www http not work https. rewriteengine on rewritebase / rewritecond %{http_host} ^www\.(.*)$ [nc] rewriterule ^/(.*)$ http://%1/$1 [r=301,l] rewritecond %{https} off rewriterule ^(.*)$ https://domainname.com.au/$1 [r=301,l] rewriterule ^code-of-conducts/(.*)/$ code-of-conducts.php?type=$1 rewriterule ^parents/post-a-job/(.*)/edit/$ parents/post-a-job.php?action=edit&id=$1 rewriterule ^parents/post-a-job/(.*)/$ parents/post-a-job.php?job_type=$1 rewriterule ^parents/open-jobs/(.*)/delete/$ parents/open-jobs.php?action=delete&id=$1 rewriterule ^parent-profile/(.*)/$ parent-profile.php?id=$1 rewriterule ^parents/job-details/(.*)$ parents/job-details.php?applied_id=$1 rewriterule ^sitterprofile/(.*)/$ sitterprofile.php?id=$1 rewriterule ^sitter/job-board/state/(.*)/page/(.*)/$ sitter/job-board.ph...
Read more