Forum Discussion

Anonymous

Jun 06, 2022

Solved

can anybody help me using SUMIFS Function or other functions to deal with this issue?

can any genius help me to use the excel function to do the calculation of the fruits? I was trying to use COUNTIF or AGGREGATE, but failed: I planned to make the count rule as: the first ...

Formulas and Functions

Riny_van_Eekelen
Jun 06, 2022
Like so:

Riny_van_Eekelen

Platinum Contributor

Jun 06, 2022

Like so:

TipsyQ

Copper Contributor

Jun 06, 2022

Thank you sir, this if very helpful!

mtarler
Silver Contributor
Jun 06, 2022
NOTE that the secret sauce to Riny's equation is the use of the $ in $B$3 because as you copy down those $ force that reference to stay the same while the other reference B3 without the $ will offset accordingly to B4, then B5, .... etc....