formula help

P

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
 
P

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
 
P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top