Search code examples
excelexcel-formulasumworksheet-functionsumifs

SUM(IF(ColA=ColA AND ColB=ColB,ColC,0)

This SUMIF calculation has stumped me within Excel (2013).

A           B            C          D         E    
Created     Source       Conv       Rev       RPConv
Jan,1 2014  Apples       3          5.00      =Rev/Conv
Jan,1 2014  Oranges      2          4.00      =Rev/Conv
Jan,7 2014  Apples       3          5.00      =Rev/Conv
Feb,1 2014  Apples       5          5.00      =Rev/Conv
Feb,1 2014  Oranges      3          4.00      =Rev/Conv

CURRENT: =SUM(IF(MONTH($A:$A)=1 AND $B:$B='Apples',$D:$D,0)

What I expect to return is:

5.00+5.00

but unfortunately it rejects the statement altogether.

Solution

  • Given the tag and assuming Month 1 is January 2014: 

    =SUMIFS(D:D,A:A,">"&41639,A:A,"<"&41671,B:B,"Apples")