Hello - I am trying to figure out how to call out a group of cells and sum them that have the same name.
For example.
I am on TAB A trying to put together a Summary Tab.
on Tab B Is a list of values for 5 categories (let's say apple, orange, banana, etc.).
I want to say "Hey tab b, if the word apple is in Column A, look at column X for the value and sum all of those).
Does that make sense? How do I do that?
Thanks, Keri
maybe sum(if....
A1=banana
=SUM(IF(category=A1, column to sum))
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
It didn't work, I think b/c they are on different tabs.
Hi
Why Vlady's formula, does not works for you?
In Excel,if we want to say:
"Hey tab b, if the word apple is in Column A, look at column X for the value and sum all of those)", then we say.
Is this, works for you?
Please Login or Register to view this content.
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.
OMG That's great - it worked. THANK YOU THANK YOU THANK YOU!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks