Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sub total
Use "sumif" command.
sumif(range of criteria,critera, the range to bu summed) in your case sumif(column B,"put the discription, you want the sum for them",column C) HTH "Tarig" wrote in message ... I have a master data sheet that contains reciept numbers in column "A", description in column "B" and amount in column "C". I need a formulae that can sum amounts with the same similar description. Thanks in advance tarig |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sub total
I have a master data sheet that contains reciept numbers in column "A",
description in column "B" and amount in column "C". I need a formulae that can sum amounts with the same similar description. Thanks in advance tarig |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sub total
Try using the SumIf...
Sandy Tarig wrote: I have a master data sheet that contains reciept numbers in column "A", description in column "B" and amount in column "C". I need a formulae that can sum amounts with the same similar description. Thanks in advance tarig |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sub total
Try using the SumIf function...
Sandy Tarig wrote: I have a master data sheet that contains reciept numbers in column "A", description in column "B" and amount in column "C". I need a formulae that can sum amounts with the same similar description. Thanks in advance tarig |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sub total
Thanks for your help, I have used successfully sumif command
-- tarig elsawi "Rasoul Khoshravan" wrote: Use "sumif" command. sumif(range of criteria,critera, the range to bu summed) in your case sumif(column B,"put the discription, you want the sum for them",column C) HTH "Tarig" wrote in message ... I have a master data sheet that contains reciept numbers in column "A", description in column "B" and amount in column "C". I need a formulae that can sum amounts with the same similar description. Thanks in advance tarig |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating Business Hours Between 2 Dates | Excel Discussion (Misc queries) | |||
Subtotal | Excel Worksheet Functions | |||
% of running total in pivot table | Excel Discussion (Misc queries) | |||
How to total itmes if they fall between a date range | Excel Worksheet Functions | |||
How to total items if they fall between a date range | Excel Discussion (Misc queries) |