Dear all,
Could you please help me with this SUMFS function:
=SUMIFS('ENV NCR List'!$AD$3:$AD$20570,'ENV NCR List'!$J$3:$J$20570,">="&$F$50,'ENV NCR List'!$J$3:$J$20570,"<="&$F$51,'ENV NCR List'!$I$3:$I$20058,"==2015")
I have prbolem with the last (highlighted) only...
Please help me. Thank you.
All sumif(s) ranges should have unique cell count (in Criteria Range).
'ENV NCR List'!$I$3:$I$20058
Should be changed to
'ENV NCR List'!$I$3:$I$20570
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
Oh ok.
Solved.
Thanks alot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks