Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a list of suppliers with dollar amounts across from them in a
different cell. I want to be able to total up the amount per supplier. Can you count the dollar amount by supplier? Thank You For Your Help, Kevin |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Yes have alook at the sumif function sumif(supplier range,criteria,dollar range) If the data was in the range a1:b40 sumif(a$1:a4$0,"supplier1",b$1:b$40) Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=509314 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If the names are in column A and amounts in B, the total is
=sumif(A:A,"Supplier X",B:B). You might also consider a Pivot Table; drop the suppliers into the Rows field and amounts in the data field. --Bruce "Kevin" wrote: I have a list of suppliers with dollar amounts across from them in a different cell. I want to be able to total up the amount per supplier. Can you count the dollar amount by supplier? Thank You For Your Help, Kevin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions |