| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to add one column if 2 other columns have a specific value
I'm trying to get the sum of column F(Revenue dollars) if column B = Jan,
Feb, or Mar AND column D = YP. I have tried SUMIF and SUMPRODUCT, but can't figure it out... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to add one column if 2 other columns have a specific value
See if this helps:
http://www.officearticles.com/excel/...ft_excel.h tm ************ Hope it helps! Anne Troy www.OfficeArticles.com "jettp" wrote in message ... I'm trying to get the sum of column F(Revenue dollars) if column B = Jan, Feb, or Mar AND column D = YP. I have tried SUMIF and SUMPRODUCT, but can't figure it out... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to add one column if 2 other columns have a specific value
Anne, this was helpful in adding column B for one month, but I need the
formula for adding column B if it is Month 1, Month 2, or Month 3. Do you have any other suggestions? "Anne Troy" wrote: See if this helps: http://www.officearticles.com/excel/...ft_excel.h tm ************ Hope it helps! Anne Troy www.OfficeArticles.com "jettp" wrote in message ... I'm trying to get the sum of column F(Revenue dollars) if column B = Jan, Feb, or Mar AND column D = YP. I have tried SUMIF and SUMPRODUCT, but can't figure it out... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Need a function to fill column from other columns | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Combining mutiple columns into one column | Excel Worksheet Functions | |||
| print 3 column range in six columns | Excel Discussion (Misc queries) | |||
Linear Mode
