Forum Discussion
Using SumIfs with individual groups
Hi all, I'm trying to calculate sums of certain items from a drop-down list, only if a certain checkbox is checked. Only problem is, there are multiple entries in the same sheet. I'll start with...
Hi chanisorkin
In each of your grouped rows, below the green headers cells in column E don't seem to be used. Just an idea... in cells E reference the School textbox in column I (absolute row#) and copy down to the next cells:
then format cells in column E with a white font (not done above)
Formula in M2 above:
=SUMIFS(G:G, E:E,TRUE, F:F,L2)