Hi
how do I make a formula that finds what's in F3 and search in Row 20 and sums everything below where E is "product 1". I can't use a standard SUMIFS but I think i need to combine it with a MATCH, INDEX or the like. Please see attachment and help
br, Alexander
Enter formula in F4 and copy down
Formula:
Please Login or Register to view this content.
v E F G H I J 3 Shop A Shop B Shop C Shop D Shop E 4 Product 1 311037.7 9315 -1972535.5 1204846.9 -421206.1 5 Product 2 9 42 9 42 42 6 Product 3 0 0 0 0 0 7 Product 4 -620146.5 1269.2 -1735294.7 225231.3 -493675.3 8 Product 5 -482005.2 1324.6 -2366853.6 805152 19879.2
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
that works great! thanks! can you also explain me in words what it actually does?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks