LinkBack URL
About LinkBacks
You threw me however with your expected result, the correct answer is 100 not 300. Only row 8 contains "AIR" and a weight between 300 and 500
=SUMIFS(C:C,A:A,"AIR",B:B,">300",B:B,"<500")
You threw me however with your expected result, the correct answer is 100 not 300. Only row 8 contains "AIR" and a weight between 300 and 500=SUMIFS(C:C,A:A,"AIR",B:B,">300",B:B,"<500")
If someone has helped you then please add to their Reputation
Haha...yes. I my mistake. I did it a bit too quickly...
Thank you for a quick reply!
//M
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks