I have a sum formula to sum all cells in row C where Row A = "Total Revenue" and Row B (date field) is before "10/1/2005".
Currently, the formula ignores the date argument and sums all rows where Column A = "Total Revenue".
Does anyone have any ideas?
{=SUM(IF(TRIM(A2:A15)="Total Revenue", IF(B2:B15<"10/1/2005", C2:C15)))}
Thanks!
Currently, the formula ignores the date argument and sums all rows where Column A = "Total Revenue".
Does anyone have any ideas?
{=SUM(IF(TRIM(A2:A15)="Total Revenue", IF(B2:B15<"10/1/2005", C2:C15)))}
Thanks!