Hello!
I'm trying to do that: Sum of all (Bi*Ci*Di) if Ai= "a word" for all i. I would like to enter the sum (the result) in the cell E1. I don't know if i'm clear...
I think I have to use the loop but I don't really know how!
Sorry for my English! Thank you very much if somebody can help me!!
Try:Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
TMS thank you very much it's exactly what I need! I thought I had to use VBA to do it!
Thank you again!
It's not very important but I Wonder if I can generalize the formula for columns of any lenght? Just if you have an answer but it's already ok.
You're welcome. Thanks for the rep.
You could use Dynamic Named Ranges or, perhaps better, Structured Table references. Just don't use full column references with SUMPRODUCT.
Ok, so I'll try with Structures table references I think I can do it
Thank you again!
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks