Hi I need a column to sum another column if a certain column contains/does not contain data, example attached.
In the attached example I need Column D to sum Column C if Column B contains data, similarly I want Column E to sum Column C if Column B contains no data.
Cheers
Last edited by MjRmatt; 10-05-2010 at 10:04 AM.
When you say you want to sum another column what result would you expect in columns D and E for the example you have given?
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Maybe...
In D2: =IF(B2<>"",C2,"")
In E2: =IF(B2="",C2,"")
Dom
Hi Mat... I am not sure if i understand your requirement but below is something i can contribute...
type forumula in cell D2 for Allocated Sum=SUMIF(B2:B1048576,"*",C2:C1048576)
and in Cell E2 for Unallocated Sum =SUMIF(B2:B1048576,"",C2:C1048576)
Thanks...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks