LinkBack URL
About LinkBacks
Hi.
Could anyone look at the enclosed sheet and give a suggestion to why i get #VALUE and not a result??
=SUMIFS($C$2:$C$177;E2;A2;B2;F2) is what i have tried...
excelforumfile.xlsx
Nicolai
Hi.
Could anyone look at the enclosed sheet and give a suggestion to why i get #VALUE and not a result??
=SUMIFS($C$2:$C$177;E2;A2;B2;F2) is what i have tried...
excelforumfile.xlsx
Nicolai
Last edited by Vestlink; 02-05-2015 at 04:14 AM.
Try this in G2 and Drag down:-
Formula:
Please Login or Register to view this content.
The Criteria ranges should be equivalent to Sum Range in SIZE to avoid #VALUE Error.
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
EXCELLENT :-)
It broaden my excel understanding one notch :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks