Sumif multiple criteria
Trying to figure out a formula that references a text list. If someone chooses one text (Work Hours), I want it to sum, but if they choose another text (Total Hours), I want it to do a calculation. I basically want to combine these two formulas. I was thinking SUMIF(OR, but can't seen to get it right.
SUMIF (this says that) OR SUMIF (that says this)*0.8
Last edited by jlowndes; 03-11-2022 at 03:15 PM.
Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
Hi there.
A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.
Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
says I'm not allowed to post images until ive posted a few times.. stay tuned
Not so. You can not post links... but you can post an xlsx. Re-read the instructions.
I'm trying to do a sumif formula in column d.
If column B says "total hours" I want it to take column c and subtract column e, but if column b says "work hours" I want it to stay the same number as column c (or =SUMIF(B8,"work hours",C8)
How do I combine these 2 forumlas in one cell =SUMIF(B7,"*Total Hours*",C7)-E7 AND =SUMIF(B8,"work hours",C8)
=C7-IF(LEFT(B7,5)="Total",E7,0)
How about this?
=SUMIF(Table1[Works Hours or Total Hours],"*Total Hours*",Table1[Hours])-SUMIF(Table1[Works Hours or Total Hours],"*Total Hours*",Table1[Leave
Hours])+SUMIF(Table1[Works Hours or Total Hours],"*Work Hours*",Table1[Hours])
Hi to all!
Another ones in D7:
=C7-E7*COUNTIF(B7,"Tot*")
=C7-E7*(LEFT(B7,3)="Tot")
Blessings!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks