Search results for query: *

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...

I have every value, I want to lookup also the row value of the same cells, in this case H I currently lookup E cells and then get values from H cells, I then want to get the row value of the same value in the above example 220

Yes, add everything associated to number in cell B15 and then get that row info also so if it .... here is some more info... as you can see below if I put 220 in CELL B15 i locate the 220's below then get totals H's, I then want to add the row value from row 220 leyland daf recovery yes...

Hello, I have this forumla =SUMIF('EXPENSES SALES'!E61:E574,B15,'EXPENSES SALES'!H61:H574) Instead of gathering totals in this region H61:H574 I would like also to get the total from the row id entered into cell B15 ... to try and make in clear, get some totals of all rows and have the value...

Yes thats great thxs

In english (for me) does this say, if the cell is not equal to no and the other cell is not equal to yes then... blah blah