Nested Functions with SUMIF and TEXT Not Working

**Jerryz** · 10-31-2014, 08:40 PM

I am trying to add up all of the dividends paid per month, where Column A has the date, Column B has text (Interest or Dividend), Column D has the amount.

So I need to determine that, for example, when the month in column A = "January" and the text in column B = "Dividend", add the appropriate cells in column D.

I've been trying to test the following formula just to see whether I can sum all of the amounts from January, without considering column B, but I can't even get that to work. It always returns "0" even though column D has amounts.

=SUMIF(A4:A14,(TEXT(A4,"mmmm")="January"),D4:D14)

Can someone please provide guidance as to how I might create the correct formula? I am using Office 2011 for Mac.

Thank you!

Jerry

**Richard Buttrey** · 10-31-2014, 08:53 PM

Difficult to be certain since you haven't uploaded the workbook and it's not clear whether column A contains proper date numbers or text strings. Neither is it clear why you are referencing A4 as the criteria since it's usual to have a summary list of months in which you want the totals from all the dates in column A.

However try

Formula:

Please Login or Register  to view this content.

Otherwise upload your workbook.

Have you considered a Pivot Table?

**Jerryz** · 11-01-2014, 04:52 PM

Thank you Richard. That helped. All I did was to add the third range and criteria to search for "Dividend" and it is now working. Worksheet attached. The formula is in column N. See attached.

Thanks again!!!

Jerry