HI
I am using a formula
=IF(AND(C14>=$A$1,C14<=$B$1),E14,0)
Where all these cells are date fields
Now, I have to apply for over 1000 rows (c14 to c1014) and for 5 different set of columns
Is there a simple way that I can get the sum of all these 1000 rows in a single formula. I do not want to use the same formula 1000 times to get the desired result
To put is simple, instead of using this formula 1000 times and then do the sum of all of them, I want to get the sum in 1 formula, which applies this criteria 1000 times and gives me the sum of all of them
Bookmarks