[Boards: 3 / a / aco / adv / an / asp / b / bant / biz / c / can / cgl / ck / cm / co / cock / d / diy / e / fa / fap / fit / fitlit / g / gd / gif / h / hc / his / hm / hr / i / ic / int / jp / k / lgbt / lit / m / mlp / mlpol / mo / mtv / mu / n / news / o / out / outsoc / p / po / pol / qa / qst / r / r9k / s / s4s / sci / soc / sp / spa / t / tg / toy / trash / trv / tv / u / v / vg / vint / vip / vp / vr / w / wg / wsg / wsr / x / y ] [Search | Free Show | Home]

Need help for Excel formula

This is a blue board which means that it's for everybody (Safe For Work content only). If you see any adult content, please report it.
  1. Home
  2. /wsr/ - Worksafe Requests
  3. Need help for Excel formula
Thread replies: 3
Thread images: 1

Anonymous
Need help for Excel formula 2017-06-08 05:00:39 Post No. 328395
[Report] Image search: [Google]
File: HELP.png (10KB, 1355x194px) Image search: [Google]
HELP.png
10KB, 1355x194px
Need help for Excel formula Anonymous 2017-06-08 05:00:39 Post No. 328395 [Report]
I have an excel worksheet that contains data as pic related

I want to create a formula (not VBA, unless it is mandatory) so that I can multiply the values under "POT(MW)" by a column established in another sheet. Note that this must be for each row

Ive tried doing SUMPRODUCT(D3:JC3*(D2:JC2="POT(MW)"), A2:A53)

However, this doesnt work, as each unit (U1, U2, U6...) contains 5 columns, which creates an array in D3:JC3*(D2:JC2="POT(MW)" with a dimension bigger than the one I need to multiply by (A2:A53)

Is there a way to make this with a formula or do I need to hop into VBA? My problem is creating an array formed only by the columns "POT(MW)"
>>
Anonymous 2017-06-08 05:25:40 Post No.328403
[Report]
Anonymous 2017-06-08 05:25:40 Post No.328403 [Report]
>>328395
Thinking about it I also accept VBA code, as I think a formula would be unnecessary complex and hard to handle
>>
Anonymous 2017-06-09 06:38:00 Post No.328871
[Report]
Anonymous 2017-06-09 06:38:00 Post No.328871 [Report]
Unsure, done nothing that complicated before.

Maybe press F4 to make your references absolute.
Thread posts: 3
Thread images: 1
[Boards: 3 / a / aco / adv / an / asp / b / bant / biz / c / can / cgl / ck / cm / co / cock / d / diy / e / fa / fap / fit / fitlit / g / gd / gif / h / hc / his / hm / hr / i / ic / int / jp / k / lgbt / lit / m / mlp / mlpol / mo / mtv / mu / n / news / o / out / outsoc / p / po / pol / qa / qst / r / r9k / s / s4s / sci / soc / sp / spa / t / tg / toy / trash / trv / tv / u / v / vg / vint / vip / vp / vr / w / wg / wsg / wsr / x / y] [Search | Top | Home]

I'm aware that Imgur.com will stop allowing adult images since 15th of May. I'm taking actions to backup as much data as possible.
Read more on this topic here - https://archived.moe/talk/thread/1694/


If you need a post removed click on it's [Report] button and follow the instruction.
DMCA Content Takedown via dmca.com
All images are hosted on imgur.com.
If you like this website please support us by donating with Bitcoins at 16mKtbZiwW52BLkibtCr8jUg2KVUMTxVQ5
All trademarks and copyrights on this page are owned by their respective parties.
Images uploaded are the responsibility of the Poster. Comments are owned by the Poster.
This is a 4chan archive - all of the content originated from that site.
This means that RandomArchive shows their content, archived.
If you need information for a Poster - contact them.