skaswani
02-28-2008, 08:13 AM
Hello
this is my code : =COUNTIF('SCN Site Format'!M:M,'Branch- Summary'!A7) and it is working fine, but what i need to do is to count only those records whom are marked "PAID" on
Sheet : SCN Site Format
Coloumn Name : O
same with Sumif()
=SUMIF('SCN Site Format'!M:M,'Branch- Summary'!A7,'SCN Site Format'!J:J)
same with this also, i want only Paid data in column O in SCN Site Format Sheet
please guide me
thanks,
this is my code : =COUNTIF('SCN Site Format'!M:M,'Branch- Summary'!A7) and it is working fine, but what i need to do is to count only those records whom are marked "PAID" on
Sheet : SCN Site Format
Coloumn Name : O
same with Sumif()
=SUMIF('SCN Site Format'!M:M,'Branch- Summary'!A7,'SCN Site Format'!J:J)
same with this also, i want only Paid data in column O in SCN Site Format Sheet
please guide me
thanks,