Count if function
Hi Bhalchandra here,
I have Excel 2003. A B C D E F G Act.Desc STATUS Dec-09 Jan-10 Feb-10 Mar-10 Apr-10 Act 1 Plan 0.6 0.9 0.9 3 Act 1 Actual 0.6 0.6 0.6 Act 2 Plan 0.3 0.45 0.45 1.5 Act 2 Actual 0.6 0.6 0.6 Act 3 Plan 0.7 1.05 1.05 3.5 Act 3 Actual Act 4 Plan 0.3 0.45 0.45 1.5 Act 4 Actual Act 5 Plan 0.75 1.125 1.125 3.75 Act 5 Actual Sum Plan 2.65* 3.975 3.975 13.25 Actual 0 1.2 1.2 1.2 Count Plan Actual Average Plan Actual =sumif($b$3:$b$14,"Plan",C$3:C$14) =sumif($b$3:$b$14,"Acual",C$3:C$14) I want countif and average function work like sumif function. How it work? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
All times are GMT +1. The time now is 12:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com