How to SUMIFS and move Criteria Range depend on Criteria?

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Next Question:
If you are unhappy with your current Job and you don't have any other alternativ...
Posted by:
Younes El-Kojok
26-January-2016

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

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.

1 Answers

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/

Downvote Reply () Report

Popular Searches

Sales Executive Jobs Engineers Jobs Engineering Technicians Jobs Accountant Jobs Driver Jobs

Write Your Answer

More Questions Like This

Column A = "Date of birth" | Column B contains date =14/6/89 | How to get Column C result = Date Of Birth is14/6/89
Top Answer: <p>It can be done using this</p> <p>=+CONCATENATE(A1," ","is"," ... See More

Answers (13)
I have a table column eg (invoice) invoice its(is identity is on increment by one)?
Top Answer: @@IDENTITY returns the last identity value generated for any table in the current session, across all sc ... See More

Answers (4)
A) What is the last sum-day of the 21st century? B) How many sum-days are there in the 21st century?
Top Answer: <p> </p> <p>A) The last sum-day of the21st century is December31,2043, because12+31=43, ... See More

Answers (1)
If you want to combine 2 column in 1 row which formula do u use For example A5 Date B5 Invoice no. 115 Show in one colum 31.8.2015115?
Top Answer: " C " is the correct answer See More

Answers (3)

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.