Hello,
What am I doing wrong in this formula? I want to have the sum as a result. The formula needs to look for the exact match in column I according to the text in src!Vx.
Thanks for your advice!
R.
Formula:
Please Login or Register to view this content.
I cannot answer definitively, but SUM(SUMIFS()) wouldn't be an Array Formula in Excel.
Trevor Shuttleworth - Excel Aid
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
Aha that could be a possible solution.
How would I be able to create a sum in Excel with that array?
Again, educated guess:Formula:Please Login or Register to view this content.
Thanks for the rep.
Nope, it only keeps src!V2 in account and not the other values.
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks