| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need your help Dear Vba Guru's..."Creating range in a variable data.."
My Dear Vba Guru's,
I'm doing a "sumif" formula for this project, my range is the "code" and "downloads". My problem is the "code" is based on the "content type" column and the "code" is only unique per "content type" If i make a "sumif" formula without creating a range per content type group my value will be overstated since the formula will compute also the same code which is belong to the other "content type". The content type range always varies so i can't make a fixed range also. Here's the table below for your reference; Content Type Code Downloads Anime a 1 Anime a 1 Anime b 1 Logos c 1 Logos a 1 Logos b 1 Ringtones e 1 Rintones b 1 Many many thanks in advance!!! Jerome |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
I need your help Dear Vba Guru's..."Creating range in a variable data.."
=sumproduct(--(A1:A100="Anime"),--(B1:B100="a"))
-- Regards, Tom Ogilvy wrote in message oups.com... My Dear Vba Guru's, I'm doing a "sumif" formula for this project, my range is the "code" and "downloads". My problem is the "code" is based on the "content type" column and the "code" is only unique per "content type" If i make a "sumif" formula without creating a range per content type group my value will be overstated since the formula will compute also the same code which is belong to the other "content type". The content type range always varies so i can't make a fixed range also. Here's the table below for your reference; Content Type Code Downloads Anime a 1 Anime a 1 Anime b 1 Logos c 1 Logos a 1 Logos b 1 Ringtones e 1 Rintones b 1 Many many thanks in advance!!! Jerome |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
I need your help Dear Vba Guru's..."Creating range in a variable data.."
Thanks a lot Tom!! It works!!! Great!!!
Tom Ogilvy wrote: =sumproduct(--(A1:A100="Anime"),--(B1:B100="a")) -- Regards, Tom Ogilvy wrote in message oups.com... My Dear Vba Guru's, I'm doing a "sumif" formula for this project, my range is the "code" and "downloads". My problem is the "code" is based on the "content type" column and the "code" is only unique per "content type" If i make a "sumif" formula without creating a range per content type group my value will be overstated since the formula will compute also the same code which is belong to the other "content type". The content type range always varies so i can't make a fixed range also. Here's the table below for your reference; Content Type Code Downloads Anime a 1 Anime a 1 Anime b 1 Logos c 1 Logos a 1 Logos b 1 Ringtones e 1 Rintones b 1 Many many thanks in advance!!! Jerome |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating a "date selector box" or "pull down box" in a cell | Excel Worksheet Functions | |||
| "Type mismatch" when I try to fill an Array variable with "+" | Excel Discussion (Misc queries) | |||
| use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
| Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc | Excel Programming | |||
| Exel2000 VBA - Creating a Command Bar - Error: "Object Variable or With not Set" | Excel Programming | |||
Hybrid Mode
