| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMIF with the criteria range
I have problem to use formula SUMIF(RANGE, CRITERIA, RANGE)
I want to summarize range according to criteria which is range. In my case Criteria is range A1:A5 I know that i can write formula in this way: =SUMIF(RANGE, A1, RANGE) +SUMIF(RANGE, A2, RANGE)+SUMIF(RANGE, A3, RANGE)+SUMIF(RANGE, A4, RANGE)+SUMIF(RANGE, A5, RANGE) Can i write this formula in a easier way? sometimes i have criteria range long list and i want to write compact formula. Can you help me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif when criteria range is larger but includes criteria | Excel Programming | |||
| sumif when criteria range is larger but includes criteria | Excel Programming | |||
| SumIf - when I fill down the Range, Criteria & sum range changes | Excel Worksheet Functions | |||
| sumif when criteria is a range | Excel Discussion (Misc queries) | |||
| SUMIF with AND for range and criteria | Excel Worksheet Functions | |||
![Lado Kiknadze[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
