Sum, Sum if or if???????

  • Thread starter Thread starter The Cat
  • Start date Start date
T

The Cat

I have trouble with a formula and I am hoping that someone can help
me.

This is the formula I currently have in place:
=SUM(IF((OSS!$V$2:$V$100="OSS")andif(OSS!$D$2:$D$100="Jan-04"),OSS!O$2:O$100,0))

Although, I am trying to say that if the worksheet (oss) has OSS
written in, in column C AND IF the date is Jan 04 in column D - then
sum the respective totals from column O, if neither then put a 0 in
place.

Can someone help?
 
Hi
try
=SUMPRODUCT((OSS!$V$2:$V$100="OSS")*(MONTH(OSS!$D$2:$D$100)=1)*(YEAR(OS
S!$D$2:$D$100)=2004),OSS!O$2:O$100)
 
Hi,
Use SUMPRODUCT not SUM
=SUMPRODUCT(--(OSS!$V$2:$V$100="OSS"),--(OSS!$D$2:$D$100=A1),OSS!O$2:O$100)
Note I have put the test date in a cell since typing it in the formula is
tricky.
You could use
=SUMPRODUCT(--(OSS!$V$2:$V$100="OSS"),--(OSS!$D$2:$D$100=37990),OSS!O$2:O$10
0)
Bernard
 
Back
Top