Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formulas-
what is the proper way of entering a formula if you want to sum colum a if
colum b is 03-01-05 but <04-01-05 |
#2
|
|||
|
|||
One way:
=SUMPRODUCT((B1:B100DATEVALUE("03/01/05"))*(B1:B100<DATEVALUE("04/01/05"))* A1:A100) You do realize, that your parameters will *not* sum the entire month of March. What you posted (03-01-05), will exclude the first day of the month. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "mpiton" wrote in message ... what is the proper way of entering a formula if you want to sum colum a if colum b is 03-01-05 but <04-01-05 |
#3
|
|||
|
|||
Alternatively:
=SUMIF(A:A,"3/1/05",B:B) - SUMIF(A:A,"=4/1/05",B:B) In article , mpiton wrote: what is the proper way of entering a formula if you want to sum colum a if colum b is 03-01-05 but <04-01-05 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with named formula's | Excel Worksheet Functions | |||
Formulas | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |