| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to sum a column if two cells in row are equal
Try:
=SUMPRODUCT((B2:B5=C2:C5)*(D2:D5)) =SUMIF(A2:A5,""&TODAY()-90&"",D2:D5) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying a column of single cells into a column of merged cells | Excel Discussion (Misc queries) | |||
| transfer data into row cells from column cells in Excel | Excel Discussion (Misc queries) | |||
| Question about copying column of cells and...... | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Hybrid Mode
