formula help

[picktr]

Not sure what to use here?

I need 2 formulas
One for cell B3 and
One for cell C3
calculating within a range D3:I3

What I need.

Cell B3
If any cell within the range D3:I3 is equal to the letter X
then SUM the occurances of X and multiply by $5.00
else $0.00

Cell C3
If any cell within the range D3:I3 is equal to $5.00 then sum al
instances of $5.00.
else $0.00

I have attached an example, (no macros)
Thanks,
To

Attachment filename: example1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=55321

 

[Peo Sjoblom]

Try

=COUNTIF(D3:I3,"X")*5

=SUMIF(D3:I3,5)

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[picktr]

Peo,

It didn't work.

Did you view my attachment?

tom

 

[Peo Sjoblom]

I don't view attachments for several reasons, most regulars
don't. If you described it correctly the formulas I provided
should work. What did not work?

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[picktr]

Me,

I did not work. Copied formula to wrong cell.


Got it though!

Thanks