| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
URGENT - SUMIF(AND
I am trting to SUMIF a single range based on 2 columns . I'll explain.
City= New York, Washington, Miami etc Area = Direct Sales, Call Centre, Third Party etc Sales in $ How can I create a formula to tell me how much has been sold by the Miami Call centre? Thanks -- Griggs |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
URGENT - SUMIF(AND
why dont you use a pivot table instead ?
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
URGENT - SUMIF(AND
=sumproduct((a2:a22="New York")*(b2:b22="Call Centre")*c2:c22)
-- Don Guillett SalesAid Software "Griggs" wrote in message ... I am trting to SUMIF a single range based on 2 columns . I'll explain. City= New York, Washington, Miami etc Area = Direct Sales, Call Centre, Third Party etc Sales in $ How can I create a formula to tell me how much has been sold by the Miami Call centre? Thanks -- Griggs |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
URGENT - SUMIF(AND
hi Griggs
=sumproduct(--(a2:a1000="miami")*(b2:b1000="call centre");(c2:c1000)) hth regards from Brazil Marcelo "Griggs" escreveu: I am trting to SUMIF a single range based on 2 columns . I'll explain. City= New York, Washington, Miami etc Area = Direct Sales, Call Centre, Third Party etc Sales in $ How can I create a formula to tell me how much has been sold by the Miami Call centre? Thanks -- Griggs |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IME MODE FOR EXCEL 2007 (URGENT URGENT) | Excel Discussion (Misc queries) | |||
| sumif with 3 condition - urgent | Excel Discussion (Misc queries) | |||
| Urgent SUMIF problem | Excel Worksheet Functions | |||
| basic sumif function help (urgent) | Excel Worksheet Functions | |||
| sumif help ---urgent | Excel Worksheet Functions | |||
Linear Mode
