[Here Iam trying to use sumifs with index match formula to bring the data from the raw data sheet and also using Month Validation but it is not workin

[naru88]

 

[ETAF]

rather than image - attach a sample spreadsheet
we can see whats needed
an explanation also would help

What version of excel are you using , as solutions can vary a lot depending on the version

 

[ETAF]

you need to allow access
Also an explanation of exactly what you are trying to do may help, get a solution quicker

 

[naru88]

Plz find doc link https://docs.google.com/spreadsheets/d/1j4UbrVG6e0B_OC43wO0LAFxXX8c6Ttyrmq5YM2VgVxQ/edit?usp=sharing

 

[naru88]

I Want to bring all sum data on the sheet 1 and have put month validation but it is not working

 

[naru88]

Kindly check and suggest

 

[ETAF]

is this a google sheets issue - or excel - I dont know google sheets, and some formulas are different

 

[ETAF]

perhaps
=SUMIFS(Sheet2!C$2:C$1000,Sheet2!$K$2:$K$1000,Sheet1!$B$2,Sheet2!$A$2:$A$1000,Sheet1!$C$2,Sheet2!$B$2:$B$1000,Sheet1!$A5)

as the columns on sheet1 match the order on sheet 2 - then i have not tried anything clever with also matching the header

No idea if this works in google sheets - as you did not answer

What version of excel are you using , as solutions can vary a lot depending on the version

 

[Marc L]

naru88, as a reminder this is obviously an Excel forum so very not appropriate for Google Sheets … ​

​

 

[AlanSidman]

crossposted: https://forums.excelguru.ca/threads/here-iam-trying-to-use-sumifs-with-index-match-formula-to-bring-the-data-from-the-raw-data-sheet-and-also-using-month-validation-but-it-is-not-workin.11729/

 

[vletm]

naru88
Please reread and follow Forum Rules - those are for Your too:

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.