Forum Discussion
Script to count and total varying window sizes
Hi. I'm working on a spreadsheet and I want to create a script where it will look at the plan name (Column A), then take the window sizes from Columns B and C and the Optional "z" and total them ...
In E2 (not in column D!):
=COUNTIFS($A$2:$A$10000, A2, $B$2:$B$10000, B2, $C$2:$C$10000, C2, $D$2:$D$10000, D2)
Fill down.
oops! Yes I meant Column E, thanks Hans. I'll give this a shot now