MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Regarding IF and/or COUNTIF Statements . . .


Posted by Barry K on November 14, 2001 4:15 PM

Question on IF and/or COUNTIF Statement . . . EXAMPLE: If column D is Labeled REP and has various numbers going down and column G, labeled NAME, has different names going down, how can I multiply per row, column D times the name (not number)?

You guys are great!! I appreciate your time and energy with this matter.

Taker easy,


Barry


Posted by Aladin Akyurek on November 14, 2001 4:35 PM


Barry --

I suppose you really don't want to multiply a name with a number.

The COUNTIF in "subject line" seems to suggest that you want to count but what?

Perhaps you can post 10 rows of your data along with the expected result(s).

Aladin

Posted by Barry K on November 14, 2001 7:09 PM

Thank you for responding . . . YES, I do . . . I sell multiple lines of phones, and in Column G, I have the different Names of the phones going down . . . for instance on Day 1 I sell 23 "3390", 14 "P280", 50 "FREE" - - For instance, the commissions are different for different phones . . . Also, to muddy the water, we sell phones in groups, at times . . . For Instance, 3 phones the same, OR 3 different phones on one order . . . Each row represents an order, so going across, I'm trying to multiply the amount of phones, by the phone NAME, by the commission . . . UNLESS someone has a better idea. I'm kinda new at this as you can tell.

Thank you again

Posted by Barry K on November 14, 2001 7:10 PM

Thank you for responding . . . YES, I do . . . I sell multiple lines of phones, and in Column G, I have the different Names of the phones going down . . . for instance on Day 1 I sell 23 "3390", 14 "P280", 50 "FREE" - - For instance, the commissions are different for different phones . . . Also, to muddy the water, we sell phones in groups, at times . . . For Instance, 3 phones the same, OR 3 different phones on one order . . . Each row represents an order, so going across, I'm trying to multiply the amount of phones, by the phone NAME, by the commission . . . UNLESS someone has a better idea. I'm kinda new at this as you can tell.

Thank you again

Posted by Aladin Akyurek on November 15, 2001 9:25 AM

Then what about my request?

If you inclined to respond to this request, select an empty cell, type =, select 10 rows of your data, hit CONTROL+SHIFT+ENTER at the same time, go the Formula Bar while in this cell, select what you see and hit F9. Copy everything after =-sign and paste it in the follow up.

Aladin