sumproduct or sumif

Hi, I would to use a sumifs formula to sum both rows and columns.. I've tried the standard sumifs and this doesn't work. Maybe sumifs isn't the best method Appreciate the support

Hi, In my example, I'm trying to create a formula that would return the "numbers of customers making up 80% of revenue". I want to sum accounts cumulatively until the target is reached "80%") (or the closest match) and count how many accounts this is. Many thanks for your help, Anthony...

Hello everyone, I've posted this on this older thread but maybe it has low visibility. I'm having a similar problem to that user, the only difference is that I have an extra criterion (date values) to be considered. I've tried variations of the solution presented in that post, unsuccessfully...

I have two worksheets (Sheet1 & Sheet 2) in my file Sheet 1 has three column (ID, Dept, and rate) Sheet 2 has three column (ID, Group #, and rate) so 3 columns on each sheet (Column A, B & C) On sheet 2, First i want to match "ID on both sheet" Second, I want to match DEPT. in sheet 1 to...