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
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 wrote:
> Dear Friends,
>
> ** **
>
> I want to put a formula in the attached sheet to calculate automatically
> as and when I change the periods., please help..
>
> **
