LinkBack URL
About LinkBacks
Similar to a query I posted earlier but can't seem to adapt it. I need to sum the total of all the numbers in column B where column A is the same. Eg....
Sheet 1
Bank 57
Shop 25
Car 32
Bank 3
Sheet 2
Bank 60
Similar to a query I posted earlier but can't seem to adapt it. I need to sum the total of all the numbers in column B where column A is the same. Eg....
Sheet 1
Bank 57
Shop 25
Car 32
Bank 3
Sheet 2
Bank 60
I think you want,
You would have to enter all the unique values in Sheet2!B:B that you want to check Sheet1 for though.
Please Login or Register to view this content.
Legend, thank you. I had it like that but was trying separate the B:B out with brackets. I'll know for next time, cheers!
Steve,try.
=SUMIF(Sheet1!a1:a4,"BANK";Sheet1!b1:b4)
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks