Add If ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GatorGirl - 08 Mar 2007 21:05 GMT

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.

Reply to this Message

T. Valko - 08 Mar 2007 21:19 GMT

>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

>I am trying to have a cell total figures if a cell in a different column
> range is met.
[quoted text clipped - 10 lines]
>
> :)

Reply to this Message

Dave F - 08 Mar 2007 21:33 GMT

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

Signature

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

> I am trying to have a cell total figures if a cell in a different column
> range is met.
[quoted text clipped - 9 lines]
>
> :)

Reply to this Message

Helge - 09 Mar 2007 15:10 GMT

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

> Two options if you don't want to use SUMIF:
>
[quoted text clipped - 4 lines]
>
> Dave

Reply to this Message

T. Valko - 09 Mar 2007 18:16 GMT

Take a look at these:

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

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

Biff

> Hi,
>
[quoted text clipped - 20 lines]
>>
>> Dave

Reply to this Message

Helge - 10 Mar 2007 15:39 GMT

Thanks a lot. That helped a lot.

Helge

> Take a look at these:
>
[quoted text clipped - 28 lines]
>>>
>>> Dave

Reply to this Message