p://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><&g
ird ranges should be of mixed
referencing.
regards
viswanathan m
On Sun, Jul 31, 2011 at 5:50 PM, Daniel wrote:
> Hi,
>
> ** **
>
> In AF2 (array formula, validate with Ctrl+Shift+Enter) :
>
> ** **
>
> =INDEX($A$1:$AE$1,1,MAX(IF($B$2:$AE$2="P",CO
om
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><
Dear Mr. John,
=SUM(NOT(B2=""),NOT(D2=""),NOT(F2=""))
The above formula will help you for finding out the Total Deliveries
*With warm regards*
*Viswanathan M*
DE(Tech)
RGM TTC Chennai-600027
*Vande* *Mataram*
On Sat, Mar 26, 2011 at 9:57 PM, John A. Smith wrot