SUMIFS help!

Excel 2007

A simple ledger where column A are dates...01/04/2013, etc.
cloumn b is categories... "Groceries" or "Fuel" or "Office Supplies"
column c is dollar amounts.... "$42.02", $14.92", etc.

I want to return the sum of all values from column C that were groceries in the month of January (or between 01/01/2013 and 01/31/2013, or any other date range I choose)

SUMIFS? I can figure out how to do it to return the sum of all groceries, but can't figure out how to incorporate the date range.

Thanks!!!

Hi,

This may help....

=SUMPRODUCT(--(MONTH(A$1:A$50)=F1)*(B$1:B$50=F2),C$1:C$50)

where F1=month serial no. (1 for Jan); F2=categories

change the range/referances as per your data.

PERFECT! These both work! nested.if1... can you explain what the -- is in your formula?

Originally Posted by CaptainO

PERFECT! These both work! nested.if1... can you explain what the -- is in your formula?

Hi,

Sorry for the confusion, It was actually not required there as we are using SUMPRODUCT with multiplication.

If you use SUMPRODUCT with commas, you need to turn true/false values into numbers first by doing math. (I prefere to do it by using "--")

If you use SUMPRODUCT with multiplication, you’re already doing math so you don’t need it.