Guys,
I have a worksheet with several columns but what I need to do is to sum values based on 2 columns info
Column F – Total / Column G - Role / Column H – Project 2
Role – PL or CM
Projects – are CBI / ICL
Total - the amount number
I would like to sum if ColumG is PL and at the same time ColumnH is CBI sum up all the values in Column F total
cbi.JPG
Like this?
Formula:
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.
Formula:Please Login or Register to view this content.
option -2Formula:Please Login or Register to view this content.
Hi try this
Punnam
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks