IF Formulas
I have a column for every month (12) and I have criteria that must be met all
months in order for annual points to be awarded. How can I tell cell P5 that if all cells from D5 to O5 each have an x in them than P5 should equal 50, but if any one cell does not have the x then P5 should equal 0? Does that make sense? I know how to tell it when I'm only looking at one cell: If(D5="x",20,0), but I need it to look at all cells on that row. I'd appreciate any help. |
IF Formulas
=(COUNTIF(D5:O5,"x")=12)*50
"Clara" wrote: I have a column for every month (12) and I have criteria that must be met all months in order for annual points to be awarded. How can I tell cell P5 that if all cells from D5 to O5 each have an x in them than P5 should equal 50, but if any one cell does not have the x then P5 should equal 0? Does that make sense? I know how to tell it when I'm only looking at one cell: If(D5="x",20,0), but I need it to look at all cells on that row. I'd appreciate any help. |
All times are GMT +1. The time now is 01:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com