Re: Multiple Condition Sumif Formula

Hi

I think your problem might be that your 'date' (in the Month column) is a
date but your 'date' in your formula is classed as text. Try typing
10/1/2004 (as a date) in a cell on its own (say X1), and use:
=SUMPRODUCT((J5:J44=X1)*(I5:I44="x")*(E5:E44))
At least that will tell you if we're on the right track!

--
Andy.


"momtoaj" <anonymous@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0f9701c53ab4$3fee8e10$a501280a@xxxxxxxxxx
> I'm trying to create a formula for the following
> conditions:
>
> column J Column I Column E
> Month: Billed: Revenue:
> 12/1/2004 x 5,000
> 11/1/2004 2,500
> 10/1/2004 x 1,000
> 10/1/2004 2,000
> 1/1/2005 3,000
> 1/1/2005 x 4,000
>
> So I want the formula to look at if the month is October
> (or 10/1/2004) & if it was billed (x), then sum the
> revenue column.
>
> This is the formula that I tried, but it is still coming
> back with a $0 answer:
>
> =SUMPRODUCT((J5:J44="10/1/2004")*(I5:I44="x")*(E5:E44))
> The result should be $1,000
>
> I've tried to enter the formula exactly as it is written
> & I've tried to enter the formula as an array by doing
> CTRL+SHIFT+ENTER, but I still get $0
>
> What am I doing wrong?, or if there is a better formula
> to use...
>
> Thanks!


.

Relevant Pages

  • permutations of text groups?
    ... selecting group A will create a box (an array?) something like this: ... I'll keep scratching around ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: Multiple Condition Sumif Formula
    ... Thanks a bunch! ... >> revenue column. ... >> & I've tried to enter the formula as an array by doing ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • uploading multiple files
    ... I have an asp.net form with multiple elements on it. ... when the form is posted, I get an array of files, but how do can I figure ... Andy ... Prev by Date: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Modifying Array inside While statement
    ... > Andy wrote: ... >>I have a perl script that takes an array and processes the arguments ... Prev by Date: ...
    (comp.lang.perl.misc)
  • Re: Looking for speed performance to draw line.
    ... each item in an array, that being the next and/or previous indexes. ... and it's next pointer to the previous item's original next pointer. ... Next -1, Prev 0 ... shapes up into shape classes that implemented the required commands ...
    (microsoft.public.vb.winapi.graphics)