I am trying to have a cell total figures if a cell in a different column
range is met.
Ex.
Column A Sales Month
Column B Sales Figure

Entries are made in random order so i want the total of sales for the month
specified in a cell.

I looked at sumif but didn't seem to work because i need to include the
range of entries to get all of the specified month.

:)

Column A Sales Month

So, what is the Sales Month? A date like 1/1/2007? The month number like 1
(for January)? A TEXT string like Jan? A DATE like 1/1/2007 formatted to
display like Jan?

Biff

"GatorGirl" wrote in message
...
I am trying to have a cell total figures if a cell in a different column
range is met.
Ex.
Column A Sales Month
Column B Sales Figure

Entries are made in random order so i want the total of sales for the
month
specified in a cell.

I looked at sumif but didn't seem to work because i need to include the
range of entries to get all of the specified month.

:)

Two options if you don't want to use SUMIF:

1) Use a pivot table. See here for more info:
http://www.cpearson.com/excel/pivots.htm

2) Use SUMPRODUCT: =SUMPRODUCT(--(A1:A100="January"),--(B1:B100)) etc.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"GatorGirl" wrote:

I am trying to have a cell total figures if a cell in a different column
range is met.
Ex.
Column A Sales Month
Column B Sales Figure

Entries are made in random order so i want the total of sales for the month
specified in a cell.

I looked at sumif but didn't seem to work because i need to include the
range of entries to get all of the specified month.

:)

Hi,

I have never used the double negative signs in any formula. I have come
across it in several Q&A in var. userforums though, so however obvious
it may be (to the the rest of you), please excuse my ignorance.

I need an explanation, what is the purpose, and the logics behind, the
double negative signs?

By testing the formula below, I see the effect but I still don't get it :-(

T.i.a.

Helge

Dave F wrote:
Two options if you don't want to use SUMIF:

1) Use a pivot table. See here for more info:
http://www.cpearson.com/excel/pivots.htm

2) Use SUMPRODUCT: =SUMPRODUCT(--(A1:A100="January"),--(B1:B100)) etc.

Dave

Take a look at these:

http://xldynamic.com/source/xld.SUMPRODUCT.html


http://mcgimpsey.com/excel/formulae/doubleneg.html

Biff

"Helge" wrote in message
...
Hi,

I have never used the double negative signs in any formula. I have come
across it in several Q&A in var. userforums though, so however obvious it
may be (to the the rest of you), please excuse my ignorance.

I need an explanation, what is the purpose, and the logics behind, the
double negative signs?

By testing the formula below, I see the effect but I still don't get it
:-(

T.i.a.

Helge

Dave F wrote:
Two options if you don't want to use SUMIF:

1) Use a pivot table. See here for more info:
http://www.cpearson.com/excel/pivots.htm

2) Use SUMPRODUCT: =SUMPRODUCT(--(A1:A100="January"),--(B1:B100)) etc.

Dave

Thanks a lot. That helped a lot.

Helge

T. Valko wrote:
Take a look at these:

http://xldynamic.com/source/xld.SUMPRODUCT.html


http://mcgimpsey.com/excel/formulae/doubleneg.html

Biff

"Helge" wrote in message
...
Hi,

I have never used the double negative signs in any formula. I have come
across it in several Q&A in var. userforums though, so however obvious it
may be (to the the rest of you), please excuse my ignorance.

I need an explanation, what is the purpose, and the logics behind, the
double negative signs?

By testing the formula below, I see the effect but I still don't get it
:-(

T.i.a.

Helge

Dave F wrote:
Two options if you don't want to use SUMIF:

1) Use a pivot table. See here for more info:
http://www.cpearson.com/excel/pivots.htm

2) Use SUMPRODUCT: =SUMPRODUCT(--(A1:A100="January"),--(B1:B100)) etc.

Dave