Re: Multiple Condition Sumif Formula

You're right, that fixed it!

Thanks a bunch!


>-----Original Message-----
>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

  • Re: Multiple Condition Sumif Formula
    ... Andy. ... > revenue column. ... > & I've tried to enter the formula as an array by doing ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Driving transistor from HC273
    ... >>There are 19,008 LEDs in the array. ... 99x192 33x576 32x594 man there's a bunch of combinations for such an ... odd number. ... Prev by Date: ...
    (sci.electronics.basics)
  • Re: Class Properties Question
    ... > I have a class with a bunch of properties and I want to loop through ... > the class properties and put them into an array. ... Prev by Date: ...
    (microsoft.public.vb.general.discussion)
  • Re: n00b input help
    ... I'm writing a program that performs arithmetic operations on ... I want to be able to type in a bunch of integers ... sort it, convert it into an array, or what-not. ... Linked lists are ...
    (comp.lang.c)
  • Re: Suggestions to increase the performance of searching my array?
    ... You can use timers and timespans and set up test cases. ... Run them a bunch of times looking for consistency, since a whole mess of things ... >> array of a Structure with a fixed length string. ... >> In cases where the first test fails, it will still perform the other two ...
    (microsoft.public.dotnet.languages.vb)