RE: Using AND and SUMIF function together
- From: Studebaker <Studebaker@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 15 Apr 2008 13:57:00 -0700
I saw a post from Peo Sjoblom from 2005 where he answered someone's question
about summing a column where the last row will be changing. He gave this
formula:
=SUM($A$1:INDEX(A:A,D1)) where A1 always the first cell and D1 holds the
last row number.
Can someone also tell me how to incorporate this INDEX function to your
function in order to sum my column O which will also have the final cell in
the column vary?
Thank you for your help!
"Studebaker" wrote:
Hello,.
I have 2 columns of invoices totals like below:
Column I Column O
Original Invoice Total Amount Shortpaid
$45,679.00 ($-255.00)
$123.00 $0.00
$1,500.00 blank
blank blank
I'm trying to sum column O to give a total of what the client still owes us.
I need to:
a) Sum column O if the amounts in column O are < 0 (which means the client
has shortpd the original invoice) AND
b) Sum column I (the amount of the original invoice) if the invoice has flat
out not been paid--so sum column I if column O is blank (not been pd) AND
column I has a number in it (if the invoice exists and there's no blank
space in column I)
I tried this but I get a "FALSE" in my cell:
=AND(SUMIF(O3:O265,"<0"),SUMIF(I3:I266,AND(ISNUMBER(I3:I266), O3:O266="")))
Can someone help with this function (no macros please)?
Thanks very much!
- References:
- Using AND and SUMIF function together
- From: Studebaker
- Using AND and SUMIF function together
- Prev by Date: Re: Chaining 6 macro modules
- Next by Date: If Function Treating Answer as a Text Box and Not a Numeric Box
- Previous by thread: RE: Using AND and SUMIF function together
- Next by thread: If Function Treating Answer as a Text Box and Not a Numeric Box
- Index(es):
Relevant Pages
|
