| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif nightmare!
I was wondering if it's possible to use sumif with multiple criteria? In a
pivot table I have periods in a column with their corresponding values by month in each row. In the left most column of the pivot table I have sorted by revenue & expenses. I need to sumif (column d:d,"revenue" and column e:e,"LY 2007", values in column f:f) Sorry for the confusion! -- Thanks for your help! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumif nightmare!
Sumproduct will be better on this case
=sumproduct(--(a2:a100=a1)*(b2:b100=b2),(c2:c100)) just a sample, a1 and b1 has the conditonal hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "TamIam" escreveu: I was wondering if it's possible to use sumif with multiple criteria? In a pivot table I have periods in a column with their corresponding values by month in each row. In the left most column of the pivot table I have sorted by revenue & expenses. I need to sumif (column d:d,"revenue" and column e:e,"LY 2007", values in column f:f) Sorry for the confusion! -- Thanks for your help! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumif nightmare!
Did I do something wrong? I entered
=SUMPRODUCT(--(A6:A845="Revenue")*(D6:D845="LY 2007"),(E6:E845)) and the formula didn't work. It gave me a value of -10 which is the value in cell E6? Thanks again! -- "Marcelo" wrote: Sumproduct will be better on this case =sumproduct(--(a2:a100=a1)*(b2:b100=b2),(c2:c100)) just a sample, a1 and b1 has the conditonal hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "TamIam" escreveu: I was wondering if it's possible to use sumif with multiple criteria? In a pivot table I have periods in a column with their corresponding values by month in each row. In the left most column of the pivot table I have sorted by revenue & expenses. I need to sumif (column d:d,"revenue" and column e:e,"LY 2007", values in column f:f) Sorry for the confusion! -- Thanks for your help! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumif nightmare!
No need to reply - it worked beautifully once I had my columns set up
properly! Thank you soooo much! -- Thanks for your help! "Marcelo" wrote: Sumproduct will be better on this case =sumproduct(--(a2:a100=a1)*(b2:b100=b2),(c2:c100)) just a sample, a1 and b1 has the conditonal hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "TamIam" escreveu: I was wondering if it's possible to use sumif with multiple criteria? In a pivot table I have periods in a column with their corresponding values by month in each row. In the left most column of the pivot table I have sorted by revenue & expenses. I need to sumif (column d:d,"revenue" and column e:e,"LY 2007", values in column f:f) Sorry for the confusion! -- Thanks for your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PivotTable Nightmare | Excel Discussion (Misc queries) | |||
| Concatenate Nightmare! | Excel Worksheet Functions | |||
| PivotTable Nightmare | Excel Discussion (Misc queries) | |||
| VLookup Nightmare! | Excel Worksheet Functions | |||
| IF Statement nightmare | Excel Discussion (Misc queries) | |||
Linear Mode
