Prev: last sort selections won't save in Excel 2007
Next: can I use IF with SUMPRODUCT?????
From: Philangr8 on 17 May 2010 12:32
I need a formular that add a specific criteria or else just put a Zero. For
example:
I want to added column a with all January's data in column b or else just
place zero fi there's no data.

a b
January 12
February 24
March 36
January 26
March 10
February 11
From: Luke M on 17 May 2010 12:43
Did you try reading the help file on the SUMIF function? (or maybe COUNTIF?)

--
Best Regards,

Luke M
"Philangr8" <Philangr8(a)discussions.microsoft.com> wrote in message
news:09C52258-5AB7-468F-81A0-F63955877708(a)microsoft.com...
>I need a formular that add a specific criteria or else just put a Zero. For
> example:
> I want to added column a with all January's data in column b or else just
> place zero fi there's no data.
>
> a b
> January 12
> February 24
> March 36
> January 26
> March 10
> February 11


 | 
Pages: 1
Prev: last sort selections won't save in Excel 2007
Next: can I use IF with SUMPRODUCT?????