Home |
Search |
Today's Posts |
#1
|
|||
|
|||
total sum in a table of different cells
Hello,
I've been trying to get the following formula: Get the total of ALL Misc (K16, K17, K27, K37) of the table H3-U59 and put the total in (Cell F50). I added a picture for easier understanding. Ive been trying with VLookup, sumif.. Thanks for any help in advance Nan PS : the ( ) means its a negative amount |
#2
|
|||
|
|||
Quote:
Dear Nanito, Good Afternoon. Please, save your worksheet at a free site, ex.: www.4shared.com, and put the link here. The image that you provided is so small and I coulīd not see exatly what you need. I believe that your question can be solved by the use of SUMPRODUCT Function, but itīs necessary to see your worksheet. Iīm wainting your answer
__________________
I hope it can help you. Best regards, Marcilio Lobão --------------------------- Belo Horizonte, Brazil |
#3
|
|||
|
|||
Quote:
Thanks for your quick reply! Here is the link: http://www.4shared.com/dir/6XzXTwTQ/sharing.html Rgds Nan |
#4
|
|||
|
|||
Quote:
Dear Nan, Good Afternoon. Use this: F50 -- =SUMPRODUCT((J5:J58="Misc.")*(K5:K58)) Tell me if it worked for you. Fell free to ask me anything about it. Happy New Year to you.
__________________
I hope it can help you. Best regards, Marcilio Lobão --------------------------- Belo Horizonte, Brazil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sub total vs Pivot Table | Excel Discussion (Misc queries) | |||
Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table Grand Total - Cells Blank | Excel Discussion (Misc queries) | |||
Pivot Table Row Total | Excel Discussion (Misc queries) | |||
Grand total time between two total cells | Excel Discussion (Misc queries) |