Mehrab Al Islam
New Member
- Joined
- Jan 9, 2014
- Messages
- 1
Im trying sum values of a certain category for a whole month. Im trying sum if but does not work
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]NOV[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]2013[/TD]
[TD]NOV [/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD]2013[/TD]
[TD]Nov[/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD]2013[/TD]
[TD]Nov[/TD]
[TD][/TD]
[TD]30[/TD]
[TD][/TD]
[TD]2013[/TD]
[/TR]
[TR]
[TD]Page[/TD]
[TD]Brand Name[/TD]
[TD]Category[/TD]
[TD]Size[/TD]
[TD]Revenue[/TD]
[TD]Rev on Ds[/TD]
[TD]Brand Name[/TD]
[TD]Category[/TD]
[TD]Size[/TD]
[TD]Revenue[/TD]
[TD]Rev on DS[/TD]
[TD]Brand Name[/TD]
[TD]Category[/TD]
[TD]size[/TD]
[TD]Revenue[/TD]
[TD]Rev on DS[/TD]
[TD]Brand Name[/TD]
[TD]Category[/TD]
[TD]Size[/TD]
[TD]Revenue[/TD]
[TD]Rev on Ds[/TD]
[/TR]
[TR]
[TD]Front page[/TD]
[TD]Brb Cables[/TD]
[TD]Building Materials[/TD]
[TD]24[/TD]
[TD]XX[/TD]
[TD]XX[/TD]
[TD]Gp[/TD]
[TD]Telco[/TD]
[TD]35[/TD]
[TD]xX[/TD]
[TD]XX[/TD]
[TD]Holcim[/TD]
[TD]Building Materials[/TD]
[TD]34
[/TD]
[TD]X[/TD]
[TD]XX[/TD]
[TD]Trnstec[/TD]
[TD]Electronics[/TD]
[TD]15[/TD]
[TD]XX[/TD]
[TD]XX[/TD]
[/TR]
[TR]
[TD]back page[/TD]
[TD]UAB[/TD]
[TD]Education[/TD]
[TD]13[/TD]
[TD]XX[/TD]
[TD]XX[/TD]
[TD]Phillips[/TD]
[TD]Electronics[/TD]
[TD]56[/TD]
[TD]XX[/TD]
[TD]XX[/TD]
[TD]Persona[/TD]
[TD]Lifestyle[/TD]
[TD]20[/TD]
[TD]XX[/TD]
[TD]XX[/TD]
[TD]Holcim[/TD]
[TD]Building Materials[/TD]
[TD]12[/TD]
[TD]XX[/TD]
[TD]XX[/TD]
[/TR]
</tbody>[/TABLE]
I need to calculate, what the total size of Building Materials category in the front page for the month and so on for each category. the problem is i can use sumif and slect the whole row as range, and put specific categories in criteria but how do i get the sum the of the size of that category? if i put the size coulum of every day in formula they say its too large. would appreciate the help
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]NOV[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]2013[/TD]
[TD]NOV [/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD]2013[/TD]
[TD]Nov[/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD]2013[/TD]
[TD]Nov[/TD]
[TD][/TD]
[TD]30[/TD]
[TD][/TD]
[TD]2013[/TD]
[/TR]
[TR]
[TD]Page[/TD]
[TD]Brand Name[/TD]
[TD]Category[/TD]
[TD]Size[/TD]
[TD]Revenue[/TD]
[TD]Rev on Ds[/TD]
[TD]Brand Name[/TD]
[TD]Category[/TD]
[TD]Size[/TD]
[TD]Revenue[/TD]
[TD]Rev on DS[/TD]
[TD]Brand Name[/TD]
[TD]Category[/TD]
[TD]size[/TD]
[TD]Revenue[/TD]
[TD]Rev on DS[/TD]
[TD]Brand Name[/TD]
[TD]Category[/TD]
[TD]Size[/TD]
[TD]Revenue[/TD]
[TD]Rev on Ds[/TD]
[/TR]
[TR]
[TD]Front page[/TD]
[TD]Brb Cables[/TD]
[TD]Building Materials[/TD]
[TD]24[/TD]
[TD]XX[/TD]
[TD]XX[/TD]
[TD]Gp[/TD]
[TD]Telco[/TD]
[TD]35[/TD]
[TD]xX[/TD]
[TD]XX[/TD]
[TD]Holcim[/TD]
[TD]Building Materials[/TD]
[TD]34
[/TD]
[TD]X[/TD]
[TD]XX[/TD]
[TD]Trnstec[/TD]
[TD]Electronics[/TD]
[TD]15[/TD]
[TD]XX[/TD]
[TD]XX[/TD]
[/TR]
[TR]
[TD]back page[/TD]
[TD]UAB[/TD]
[TD]Education[/TD]
[TD]13[/TD]
[TD]XX[/TD]
[TD]XX[/TD]
[TD]Phillips[/TD]
[TD]Electronics[/TD]
[TD]56[/TD]
[TD]XX[/TD]
[TD]XX[/TD]
[TD]Persona[/TD]
[TD]Lifestyle[/TD]
[TD]20[/TD]
[TD]XX[/TD]
[TD]XX[/TD]
[TD]Holcim[/TD]
[TD]Building Materials[/TD]
[TD]12[/TD]
[TD]XX[/TD]
[TD]XX[/TD]
[/TR]
</tbody>[/TABLE]
I need to calculate, what the total size of Building Materials category in the front page for the month and so on for each category. the problem is i can use sumif and slect the whole row as range, and put specific categories in criteria but how do i get the sum the of the size of that category? if i put the size coulum of every day in formula they say its too large. would appreciate the help