jpeg.jpg
as show in the attachment i'm unable to write the sumproduct formulae in the CELL H3, IN THE RANGE B1:G1 IF TYPE IS "A" PRODUCT RATE * QTY.
CAN ANY BODY DO THE NEEDFUL FOR THIS.
I'M A NEW LEARNER
jpeg.jpg
as show in the attachment i'm unable to write the sumproduct formulae in the CELL H3, IN THE RANGE B1:G1 IF TYPE IS "A" PRODUCT RATE * QTY.
CAN ANY BODY DO THE NEEDFUL FOR THIS.
I'M A NEW LEARNER
Use Control + Shift + Enter to place this formula in H3
There is probably a better way to do this.
Also you don't need to use all caps, the font on this website is big enough to be read without all-caps
Please Login or Register to view this content.
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.
Try this....
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
thanks speshul,
even after entering ctrl+Shift+enter is not working..thanks for the reply.
how can we do this.
thanks sktneer,
its working,simply gr8...
regards
You're welcome.
If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark your thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks