Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif and simple but multiple criteria
Hi,
I want to run a sumif that instead of returning the total of screens for a given DMA ranking, will return the number of screens in a given range (DMA Ranks 11 to 25) I had assumed that the criteria of 10,<26 would have worked, but here we are ;). This is what I have for single criteria: =SUMIF(Sheet1!H:H,Sheet2!A2,Sheet1!AF:AF) Sheet2!A2 is actually just a number as I'm working on a test worksheet. -- I need so much help, but right now, some Excel help will suffice!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif and simple but multiple criteria
Try this:
=SUMIF(Sheet1!H:H,"=11",Sheet1!AF:AF)-SUMIF(Sheet1!H:H,"25",Sheet1!AF:AF) -- Biff Microsoft Excel MVP "Jose" wrote in message ... Hi, I want to run a sumif that instead of returning the total of screens for a given DMA ranking, will return the number of screens in a given range (DMA Ranks 11 to 25) I had assumed that the criteria of 10,<26 would have worked, but here we are ;). This is what I have for single criteria: =SUMIF(Sheet1!H:H,Sheet2!A2,Sheet1!AF:AF) Sheet2!A2 is actually just a number as I'm working on a test worksheet. -- I need so much help, but right now, some Excel help will suffice!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif and simple but multiple criteria
Thank you very much. It works perfectly!!!!
-- I need so much help, but right now, some Excel help will suffice!! "T. Valko" wrote: Try this: =SUMIF(Sheet1!H:H,"=11",Sheet1!AF:AF)-SUMIF(Sheet1!H:H,"25",Sheet1!AF:AF) -- Biff Microsoft Excel MVP "Jose" wrote in message ... Hi, I want to run a sumif that instead of returning the total of screens for a given DMA ranking, will return the number of screens in a given range (DMA Ranks 11 to 25) I had assumed that the criteria of 10,<26 would have worked, but here we are ;). This is what I have for single criteria: =SUMIF(Sheet1!H:H,Sheet2!A2,Sheet1!AF:AF) Sheet2!A2 is actually just a number as I'm working on a test worksheet. -- I need so much help, but right now, some Excel help will suffice!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif and simple but multiple criteria
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Jose" wrote in message ... Thank you very much. It works perfectly!!!! -- I need so much help, but right now, some Excel help will suffice!! "T. Valko" wrote: Try this: =SUMIF(Sheet1!H:H,"=11",Sheet1!AF:AF)-SUMIF(Sheet1!H:H,"25",Sheet1!AF:AF) -- Biff Microsoft Excel MVP "Jose" wrote in message ... Hi, I want to run a sumif that instead of returning the total of screens for a given DMA ranking, will return the number of screens in a given range (DMA Ranks 11 to 25) I had assumed that the criteria of 10,<26 would have worked, but here we are ;). This is what I have for single criteria: =SUMIF(Sheet1!H:H,Sheet2!A2,Sheet1!AF:AF) Sheet2!A2 is actually just a number as I'm working on a test worksheet. -- I need so much help, but right now, some Excel help will suffice!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF WITH MULTIPLE CRITERIA? | Excel Worksheet Functions | |||
SUMIF with multiple criteria | Excel Discussion (Misc queries) | |||
Sumif with multiple criteria | Excel Discussion (Misc queries) | |||
SUMIF with multiple criteria | Excel Worksheet Functions | |||
Multiple Criteria for SUMIF | New Users to Excel |