| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum certain cells in a column based on criteria from another colum
I have a huge spread sheet that I'd like to automate. My current delima is
how to calculate a dollar amount in one cell with information from column J based on the criteria, same row, but in column N. I've tried the sumproduct information but I'm entering it in wrong ... I've read the questions here and I know this should be a relatively simply formula but I can not get my brain wrapped around it. Any help would be appreciated. Thanks Donna |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count no. of nonblank cells in one column based on criteria of ano | Excel Discussion (Misc queries) | |||
| Count Unique records based on the Criteria in another colum | Excel Worksheet Functions | |||
| Count Unique records based on the Criteria in another colum | Excel Worksheet Functions | |||
| Count Unique records based on the Criteria in another colum | Excel Worksheet Functions | |||
| Locate max value of one column based on criteria in another colum | Excel Worksheet Functions | |||
Threaded Mode
