Here is my code:
SUMPRODUCT(SUMIFS(AccessDB!R:R,AccessDB!C:C,"Time Sensitive") OR(SUMIFS(AccessDB!R:R,AccessDB!E:E,"Time Sensitive")))
I am trying to sum R:R if C:C OR E:E are labeled "Time Sensitive". I have tried variants of sum and or statements, sumifs and or, sumproduct, etc...I can only get it to work if I am looking for two variable in the same column.
Does this make sense?
sumifs.jpg
So I would want it to total 175. Not 98 (Which is column C AND E).
Is this solved?
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks