Recent content by ptweb

Hi =SUMIF(G2:G36,0,E2:E36) I would like to add a AND condition to this sum so that H2:H36 also equal 0... bit confused

Hello, I've been the the page below and think I have installed everything, how do start the ASP? APACHE is working and I've done all the cpan stuff.. http://www.apache-asp.org/install.html#Download%20and86dfc858

I have downloaded and unzip the tar files associated? what is the next step please, I have not got perl either, so I persume I need that looking at the first command line perl -MCPAN -e shell

Does anyone know is apache supports Active server pages?

I Followed this tutorial to enable me to install iis, I get the view of iis but wont let me tick it/. tut = http://adamv.com/dev/articles/iis-on-xp-home iis=iis2.dll,OcEntry,iis2.inf,,7

Done all that, my check box is not checkable

i followed the above steps to install iis in my xp home edition.Now i can see aplication server in the add remove box,but i am not able to select it,above all i can see the details of it but cant select any of option under application

Yes, thats what I followed, but the checkbox is not tickable?

IIS on winxp home Edition? I recently made adjustments to my home edition software so I could use IIS web server components, this is posted all over the web how to do this but not my problem, I did everything required and IIS is visible or selectable but the checkbox is not active, it wont...

Urrrrrrrrrrrrrrrrrrr the mannnnnnnnnn

This is neally there Ken, =SUMIF('EXPENSES SALES'!E61:E574,B15,'EXPENSES SALES'!H61:H574)+INDIRECT("H"&B15) Its just I'm reaching the row from the EXPENSES SALES sheet? Many thxs advance

I see so the INDIRECT function will surfice?

No row, not column sorry, its the row id produced by excel, the row number, the id of thr row,

Its as before first row is row numbers............. 220 ldv recovery 15000.00 221 parts ldv recovery 220 32.88 222 mot ldv recovery 220 no 65.00 223 parts ldv recovery 220 3.08 224 tax ldv...

Sorry for delay, no thats not it.... 220 is the row id ... everything related to that purchase will be given an row id so has to allow what and where the expense was for... in other words 220 parts ldv recovery 15000.00 221 parts ldv recovery 220 32.88...