Get each price per month for a category?
maximus
I have data with the entities date, name, price. I managed to get distinct categories in the Categories colume for each name with = LEFT(B2;FIND(" ";B2)). In fact I want to get for each categorie the summed up monthly prices per month.
My sheet: 
I tried:
=SUMIF(B2:B6;LEFT(B2;FIND(" ";B2));C2:C6)
However, this formula returns 0 and also does not give me the prices per categorie and per month.
I really appreciate your help!!!
barry houdini
If you want a sum on each row which will sum for the category of the current row and the month of the current row you can use SUMIFS like this
=SUMIFS(C:C;E:E;E2;A:A;">"&EOMONTH(A2;-1);A:A;"<="&EOMONTH(A2;0))
SUMIFS requires Excel 2007 or later
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: in node.js express, how to tell the HTTP request is application/json or html on the content negoition
- Next: Converting a \u escaped Unicode string to ASCII
Related
Related Related
- 1
Django annotate price per month
- 2
How to add 'per person' to a category price in woocommerce
- 3
get the count and the price of category column then group by category
- 4
How to sum each user totals per category
- 5
Finding the lowest price for each category using join sql in Hive
- 6
magento get products per page for category list
- 7
Underscore JS: get 5 items per category
- 8
price check by product if not available get category price else product price - mysql query needed
- 9
price check by product if not available get category price else product price - mysql query needed
- 10
query to get equal number of rows per category + sub category
- 11
Get Record Per Month But Also Get Zero If No Records That Month
- 12
Is the auto-renewable In-App-Purchase price per period or per month?
- 13
Regex: Get a month of each line
- 14
Get value for each day in month
- 15
Unable to get null values for the count per month
- 16
How to get the sum of sales per month?
- 17
How to get the data per month in MySQL
- 18
Using SQL how can I write a query to find the top 5 per category per month?
- 19
MySql get Sum Price and Order Count based on Month?
- 20
get minimum price variation and maximum price variation according to specific category woocommerce
- 21
get minimum price variation and maximum price variation according to specific category woocommerce
- 22
Pandas groupby category, rating, get top value from each category?
- 23
Current month each day stats per user row
- 24
How to get the number of orders for each category?
- 25
SQL: How to get Max of Variable (per category of another variable)
- 26
Get each quarter data based on month in oracle
- 27
Create Set to get Last month of Each Year
- 28
How to get SUM and COUNT data each Month?
- 29
how to get nth date of each month for an year
Comments