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
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