I need my formula to analyse numerical and text data
Hi,
you can but what is the result you are looking for once you met both
condition summarize another column??
"Nightrunning" wrote:
I need my formula to look at numerical and text data, can it do that? Eg
COUNTIF(C2:C50,"1",and D2:D50,"M") I know COUNTIF won't work, but how do I
phrase the formula? I have a ton of these to work out for a mega spreadsheet
and I am stuck!! All help appreciated!
|