SUMIF where criteria is formula

[jjsintheuk]

Hello,

=SUMIF(A2:A48,"=April",D2:D48)

I have a problem with the above formula I'm trying to create.

Column A holds dates that are pulled from another spreadsheet using a formula.
Column D holds some figures that I'm suming up.

The criteria is April.

So what I'm trying to do is sum where April appears in column A but I think the issue is that there are forumlas in column A which although soem of the cells have April in them they are the values being displayed as a result of the forumlas pulling these dates from another sheet.

Any help would be much appreciated.

Thanks

 

[T. Valko]

Hello,

=SUMIF(A2:A48,"=April",D2:D48)

I have a problem with the above formula I'm trying to create.

Column A holds dates that are pulled from another spreadsheet using a formula.
Column D holds some figures that I'm suming up.

The criteria is April.

So what I'm trying to do is sum where April appears in column A but I think the issue is that there are forumlas in column A which although soem of the cells have April in them they are the values being displayed as a result of the forumlas pulling these dates from another sheet.

Any help would be much appreciated.

Thanks

Maybe somethig like this...

=SUMPRODUCT(--(TEXT(A2:A48,"mmmm")="April"),D2:D48)

 

[lenze]

Hi and welcome to the board!!!
Probably best to give SUMPRODUCT a chance

=SUMPRODUCT(--(A2:A48="April",D2:D48)

That said, I would just use a Pivot Table

lenze

 

[jjsintheuk]

Many thanks lenze.

I'll try that out.

jj

 

[lenze]

T Valko's formula might be better for your needs if you have Dates in the field you are pulling from

lenze