Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif formula
How do you write a sumif formula using a range for the criteria. For example:
=sumif(a20:a1000,b13:b14,c20:c1000) which does not seem to work. My spreadsheet has a series of dates in column a with corresponding values column c and I want to sum column c for a particular range of dates defined by b13 and b14. A typical range would be a month. My spreadsheet will have dates and values and I want to determine sums for certain months. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF Formula | Excel Worksheet Functions | |||
Formula Help -- SUMIF | Excel Discussion (Misc queries) | |||
Nesting a sumproduct formula within a sumif formula. | Excel Discussion (Misc queries) | |||
multiply formula where 1 cell has a (sumif) formula as a result | Excel Worksheet Functions | |||
Is there a MAXIF formula similar to the SUMIF formula? | Excel Discussion (Misc queries) |