Can you explain a bit more, like how it is and how it shud be with example
On Tue, May 1, 2012 at 1:53 PM, Dhanesh Verma dhanesh.ve...@denonline.inwrote:
Dear Friends,
** **
I want to put a formula in the attached sheet to calculate automatically
as and when I change the periods.,
Hi Dhanesh,
=SUMIFS(F3:R3,F2:R2,=B3,F2:R2,=C3)
will total the periods whose date (as specified in row 2 -- appears to be
month-ending date) falls between the specified dates in B3 and C3.
=COUNTIFS(F2:R2,=B3,F2:R2,=C3)
will count the number of periods that actually appear in the table and