| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use a range in SUMIF?
I'm trying to find a month-to-date total for each of several years. I used
the following formula: =SUMIF(B3:B350,AND("="&K6,"<="&K2),L3:L350) where B3:B350 are dates K6 is the first of the month K2 is Today L3:L350 contain the amounts to total The criteria give a "#Value!" error. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Array to named range conversion... | Excel Discussion (Misc queries) | |||
| Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) | |||
| SumIf in Visible Cell Range | Excel Worksheet Functions | |||
| SUMIF multiple criteria in 1 range | Excel Worksheet Functions | |||
Threaded Mode
