Please Guys, I'm looking for a formula or function in Cell F5 that will Sum up the values in C3:C11 if the value in A3:A11 is equal to the value in E2 and the value in B3:B11 is equal to F2. An attached file has been uploaded.
Kindly assist me. Every effort is greatly appreciated.
try this...
=SUMIFS($C$3:$C$11,$A$3:$A$11,$E$2,$B$3:$B$11,$F$2)
(sorry, didn't see your second criteria)
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
This is Excellent Sam C, I really appreciate your assistance. Surely, I've voted EXCELLENT on that.
great, glad it worked for you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks