Good day - I am trying to return a value in cell R3 ("Coast Local") from sheet "JuneYTD" looking at columns A & B and row R2:AC2 (Sheet "Coast Local") the values are in column "M" in the JuneYTD sheet
I have tried index match and landing up with Sumproduct - totally confused
[SUMPRODUCT((JuneYTD!$A$2:$A$4658=A3)*(JuneYTD!$B$2:$B$4658=B3)*(JuneYTD!$E$2:$E$4658=R$2)*(JuneYTD!$M$2:$M$4658))]
Why not Sumifs()?
In R3 Cell of Coast Local Sheet
Drag the formula right and down.
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
SUMIFS is better, but you also need to delete leading/trailing spaces in Row 2 (month names " Jan " is incorrect. Should be "Jan"
=SUMIFS(JuneYTD!$M:$M,JuneYTD!$A:$A,'Coast Local'!$A3,JuneYTD!$B:$B,'Coast Local'!$B3,JuneYTD!$E:$E,'Coast Local'!R$2)
in R3, copied across and down
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks