| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
too long sumif help
Sumif working. Now its so easy.Thanks.
"Domenic" kirjutas: In that case, use SUMIF instead... =SUMIF(A1:E201,"A",A2:E202) ....it's more efficient. Hope this helps! In article , "Jaan" wrote: Hi Domenic formula SUMPRODUCT is perfect. But Bob formula not working.I hope this is my mistake.The MOD not understandability for me.Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| More than 3 conditional formats? | Excel Discussion (Misc queries) | |||
| Format cells with a formula (7 conditions). | Excel Discussion (Misc queries) | |||
| Date & Time | New Users to Excel | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
Hybrid Mode
