Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to SUMIFS and move Criteria Range depend on Criteria?

Eg. Summing column D:D as its header is today date so tomorrow I'd like to automatically move summing range to E: E instead?

Microsoft Excel
user-image
Question added by Muhammad Khalaf , Project Planner / Project Control Specialist , Consolidated Contractors International Company
Date Posted: 2018/01/24
Upvote (0) Views (1) Followers (1) Answers (1) Report Question
Write an Answer
Register now or log in to answer.
Akmaluddin Khairzada
by Akmaluddin Khairzada , Office Manager , Geo Chem Middle East Afghanistan

Sumifs(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2],...) For more details, https://www.ablebits.com/office-addins-blog/2014/11/12/excel-sumifs-sumif-multiple-criteria/

Write Your Answer
More Questions Like This