| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional sumif
Thank you Bob...it works nicely!
"Bob Umlas" wrote: =SUM(A1:OFFSET(A1,0,0,1,mo.)) assuming "mo." is the defined name, otherwise you can use the MONTH function of the cell containing the date (if the date is in Z1, for example, =SUM(A1:OFFSET(A1,0,0,1,MONTH(1))) "wilson@irco" wrote in message ... In my budget comparison worksheet, I need to compare CYTD to PTYD totals and would like to write conditional sumif that totals PYTD based on the month (i.e, total A1:A1 if mo. = 1, total A1:B1 of mo. =2, A1:C1 if mo.=3 and so on). Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional SUMIF??? | Excel Worksheet Functions | |||
| copy the conditional sum (SUMIF) formula | Excel Worksheet Functions | |||
| adding summed cells in a conditional sumif | Excel Worksheet Functions | |||
| HOW DO I COPY A CONDITIONAL SUM (sumif) AND EDIT IT? (THE SUM NEV. | Excel Worksheet Functions | |||
| Conditional Format With SUMIF | Excel Worksheet Functions | |||
Threaded Mode
