Related Posts
Scrum Product Owner
7/8 Thread (General):
Additional Posts in Excel Genius
Look out! Gonna be changing a lot around here.
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
My favorite use case: Sumproductif()
=sumproduct(--(conditional range = condition),range1, range2)
This function will multiply across range 1 and 2 if the corresponding cell in the conditional range meets your condition, if it fails the condition it’ll result in a zero, then it will add the results up