Greetings!
I'm having hard time creating a formula to sum up data linked with another variable. It's probably a simple IF -fucntion but I just can't figure it out? In the attatched sample I'm looking to create a summary of total quantity for each class. Hints, anyone?
Hi
In F4 and copy down.
=SUMIF($B$4:$B$13,E4,$C$4:$C$13)
Is this, works for you?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Yep, got it. Thanks a lot!
You are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks