| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
SUM data if meets criteria
I want to sum data in cells when the data meets the criteria given in seperate cells. SUMIF cannot handle this; can someone advise another approach using formula? e.g. project type is defined in Col A, Yearly data in Col B, C, E How to sum yearly data of Col B for each project type? Many thanks JM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I format cells with data that meets certain criteria? | Excel Worksheet Functions | |||
| extract data from table that meets set criteria | Excel Discussion (Misc queries) | |||
| Show only data that meets a certain criteria | Excel Discussion (Misc queries) | |||
| Get data if cell within a row meets criteria | Excel Discussion (Misc queries) | |||
| Averaging data that meets a criteria | Excel Worksheet Functions | |||
Threaded Mode
